MacWorld 2003 May (DVD)

home *** CD-ROM | disk | FTP | other *** search
/ MacWorld 2003 May (DVD) / Macworld Resource DVD May 2003.toast / Data / Software / Bonus / Programming / revolutionosx.sit / Revolution 1.1.1 / components / tools / revdatabase.rev < prev next >
MetaCard/Revolution Stack | 2002-04-05 | 69.1 KB | [RSTK/Revo]
open in:
MacOS 8.1 |
Win98 |
DOS
view JSON data |
view as text

This file was processed as: MetaCard/Revolution Stack (archive/metaCardStack).
This format is not currently supported by dexvert.
Confidence	Program	Detection	Match Type	Support
`1%`	dexvert	MetaCard/Revolution Stack `(archive/metaCardStack)`	magic	Unsupported
`100%`	file	POSIX shell script executable (binary data)	default
`99%`	file	a /bin/sh script executable (binary data)	default (weak)
`98%`	file	data	default
`75%`	TrID	MetaCard/Revolution stack (old)	default
`25%`	TrID	Linux/UNIX shell script	default
`100%`	siegfried	fmt/1918 MetaCard Stack (2.x)	default
`100%`	binwalkID	Executable script, shebang: "/bin/sh"	default (weak)
`100%`	xdgMime	application/x-shellscript	default (weak)
id metadata
key	value
macFileType	`[RSTK]`
macFileCreator	`[Revo]`
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 23 21 2f 62 69 6e 2f 73 | 68 0a 23 20 4d 65 74 61 |#!/bin/s|h.# Meta|
|00000010| 43 61 72 64 20 32 2e 34 | 20 73 74 61 63 6b 0a 23 |Card 2.4| stack.#|
|00000020| 20 54 68 65 20 66 6f 6c | 6c 6f 77 69 6e 67 20 69 | The fol|lowing i|
|00000030| 73 20 6e 6f 74 20 41 53 | 43 49 49 20 74 65 78 74 |s not AS|CII text|
|00000040| 2c 0a 23 20 73 6f 20 6e | 6f 77 20 77 6f 75 6c 64 |,.# so n|ow would|
|00000050| 20 62 65 20 61 20 67 6f | 6f 64 20 74 69 6d 65 20 | be a go|od time |
|00000060| 74 6f 20 71 20 6f 75 74 | 20 6f 66 20 6d 6f 72 65 |to q out| of more|
|00000070| 0c 0a 65 78 65 63 20 6d | 63 20 24 30 20 22 24 40 |..exec m|c $0 "$@|
|00000080| 22 0a 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |".......|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00000100| 02 00 00 03 00 00 04 5e | 00 0c 72 65 76 44 61 74 |.......^|..revDat|
|00000110| 61 62 61 73 65 00 12 00 | 88 30 1c 18 6f 6e 20 72 |abase...|.0..on r|
|00000120| 65 73 69 7a 65 53 74 61 | 63 6b 0a 20 20 72 65 76 |esizeSta|ck.  rev|
|00000130| 55 70 64 61 74 65 47 65 | 6f 6d 65 74 72 79 0a 65 |UpdateGe|ometry.e|
|00000140| 6e 64 20 72 65 73 69 7a | 65 53 74 61 63 6b 0a 0a |nd resiz|eStack..|
|00000150| 6f 6e 20 43 6f 6e 6e 65 | 63 74 54 6f 44 61 74 61 |on Conne|ctToData|
|00000160| 62 61 73 65 0a 20 20 69 | 66 20 74 68 65 20 6c 61 |base.  i|f the la|
|00000170| 62 65 6c 20 6f 66 20 62 | 74 6e 20 22 64 62 74 79 |bel of b|tn "dbty|
|00000180| 70 65 22 20 69 73 20 22 | 6d 79 73 71 6c 22 20 74 |pe" is "|mysql" t|
|00000190| 68 65 6e 0a 20 20 20 20 | 69 66 20 74 68 65 20 70 |hen.    |if the p|
|000001a0| 6c 61 74 66 6f 72 6d 20 | 69 73 20 6d 61 63 6f 73 |latform |is macos|
|000001b0| 20 74 68 65 6e 0a 20 20 | 20 20 20 20 69 66 20 74 | then.  |    if t|
|000001c0| 68 65 20 73 79 73 74 65 | 6d 56 65 72 73 69 6f 6e |he syste|mVersion|
|000001d0| 20 3c 20 31 30 20 74 68 | 65 6e 0a 20 20 20 20 20 | < 10 th|en.     |
|000001e0| 20 20 20 70 75 74 20 74 | 68 65 20 64 69 72 65 63 |   put t|he direc|
|000001f0| 74 6f 72 79 20 69 6e 74 | 6f 20 74 44 69 72 65 63 |tory int|o tDirec|
|00000200| 74 6f 72 79 0a 20 20 20 | 20 20 20 20 20 73 65 74 |tory.   |     set|
|00000210| 20 74 68 65 20 64 69 72 | 65 63 74 6f 72 79 20 74 | the dir|ectory t|
|00000220| 6f 20 73 70 65 63 69 61 | 6c 46 6f 6c 64 65 72 50 |o specia|lFolderP|
|00000230| 61 74 68 28 45 78 74 65 | 6e 73 69 6f 6e 29 0a 20 |ath(Exte|nsion). |
|00000240| 20 20 20 20 20 20 20 73 | 65 74 20 74 68 65 20 77 |       s|et the w|
|00000250| 68 6f 6c 65 4d 61 74 63 | 68 65 73 20 74 6f 20 74 |holeMatc|hes to t|
|00000260| 72 75 65 0a 20 20 20 20 | 20 20 20 20 69 66 20 22 |rue.    |    if "|
|00000270| 4d 79 53 51 4c 20 4c 69 | 62 72 61 72 79 22 20 69 |MySQL Li|brary" i|
|00000280| 73 20 6e 6f 74 20 69 6e | 20 74 68 65 20 66 69 6c |s not in| the fil|
|00000290| 65 73 20 74 68 65 6e 0a | 20 20 20 20 20 20 20 20 |es then.|        |
|000002a0| 20 20 61 6e 73 77 65 72 | 20 22 59 6f 75 20 6d 75 |  answer| "You mu|
|000002b0| 73 74 20 68 61 76 65 20 | 74 68 65 20 4d 79 53 51 |st have |the MySQ|
|000002c0| 4c 20 4c 69 62 72 61 72 | 79 20 69 6e 73 74 61 6c |L Librar|y instal|
|000002d0| 6c 65 64 20 69 6e 20 79 | 6f 75 72 20 45 78 74 65 |led in y|our Exte|
|000002e0| 6e 73 69 6f 6e 73 20 66 | 6f 6c 64 65 72 20 69 6e |nsions f|older in|
|000002f0| 20 79 6f 75 72 20 53 79 | 73 74 65 6d 20 66 6f 6c | your Sy|stem fol|
|00000300| 64 65 72 20 74 6f 20 63 | 6f 6e 6e 65 63 74 20 74 |der to c|onnect t|
|00000310| 6f 20 61 20 4d 79 53 51 | 4c 20 64 61 74 61 62 61 |o a MySQ|L databa|
|00000320| 73 65 2e 22 20 77 69 74 | 68 20 43 61 6e 63 65 6c |se." wit|h Cancel|
|00000330| 0a 20 20 20 20 20 20 20 | 20 20 20 73 65 74 20 74 |.       |   set t|
|00000340| 68 65 20 64 69 72 65 63 | 74 6f 72 79 20 74 6f 20 |he direc|tory to |
|00000350| 74 44 69 72 65 63 74 6f | 72 79 0a 20 20 20 20 20 |tDirecto|ry.     |
|00000360| 20 20 20 20 20 65 78 69 | 74 20 63 6f 6e 6e 65 63 |     exi|t connec|
|00000370| 74 54 6f 44 61 74 61 62 | 61 73 65 0a 20 20 20 20 |tToDatab|ase.    |
|00000380| 20 20 20 20 65 6e 64 20 | 69 66 0a 20 20 20 20 20 |    end |if.     |
|00000390| 20 20 20 73 65 74 20 74 | 68 65 20 64 69 72 65 63 |   set t|he direc|
|000003a0| 74 6f 72 79 20 74 6f 20 | 74 44 69 72 65 63 74 6f |tory to |tDirecto|
|000003b0| 72 79 0a 20 20 20 20 20 | 20 20 20 73 65 74 20 74 |ry.     |   set t|
|000003c0| 68 65 20 77 68 6f 6c 65 | 4d 61 74 63 68 65 73 20 |he whole|Matches |
|000003d0| 74 6f 20 66 61 6c 73 65 | 0a 20 20 20 20 20 20 65 |to false|.      e|
|000003e0| 6e 64 20 69 66 0a 20 20 | 20 20 65 6e 64 20 69 66 |nd if.  |  end if|
|000003f0| 0a 20 20 65 6e 64 20 69 | 66 0a 0a 20 20 6c 6f 63 |.  end i|f..  loc|
|00000400| 61 6c 20 63 69 6e 66 6f | 2c 6e 65 77 63 6f 6e 6e |al cinfo|,newconn|
|00000410| 69 64 2c 64 62 72 65 73 | 75 6c 74 0a 0a 0a 20 20 |id,dbres|ult...  |
|00000420| 70 75 74 20 22 64 62 74 | 79 70 65 22 2c 6c 61 62 |put "dbt|ype",lab|
|00000430| 65 6c 20 6f 66 20 62 75 | 74 74 6f 6e 20 22 44 42 |el of bu|tton "DB|
|00000440| 54 59 50 45 22 26 63 72 | 26 5c 0a 20 20 20 20 20 |TYPE"&cr|&\.     |
|00000450| 20 22 64 62 68 6f 73 74 | 22 2c 66 69 65 6c 64 20 | "dbhost|",field |
|00000460| 22 44 42 48 4f 53 54 22 | 26 63 72 26 5c 0a 20 20 |"DBHOST"|&cr&\.  |
|00000470| 20 20 20 20 22 64 62 64 | 61 74 61 62 61 73 65 22 |    "dbd|atabase"|
|00000480| 2c 66 69 65 6c 64 20 22 | 44 42 44 41 54 41 42 41 |,field "|DBDATABA|
|00000490| 53 45 22 26 63 72 26 5c | 0a 20 20 20 20 20 20 22 |SE"&cr&\|.      "|
|000004a0| 64 62 75 73 65 72 22 2c | 66 69 65 6c 64 20 22 44 |dbuser",|field "D|
|000004b0| 42 55 53 45 52 22 26 63 | 72 26 5c 0a 20 20 20 20 |BUSER"&c|r&\.    |
|000004c0| 20 20 22 64 62 70 61 73 | 73 77 6f 72 64 22 2c 66 |  "dbpas|sword",f|
|000004d0| 69 65 6c 64 20 22 44 42 | 50 41 53 53 57 4f 52 44 |ield "DB|PASSWORD|
|000004e0| 22 20 69 6e 74 6f 20 63 | 49 6e 66 6f 0a 0a 0a 20 |" into c|Info... |
|000004f0| 20 73 70 6c 69 74 20 63 | 69 6e 66 6f 20 62 79 20 | split c|info by |
|00000500| 72 65 74 75 72 6e 20 61 | 6e 64 20 63 6f 6d 6d 61 |return a|nd comma|
|00000510| 0a 20 20 70 75 74 20 72 | 65 76 64 62 5f 63 6f 6e |.  put r|evdb_con|
|00000520| 6e 65 63 74 28 63 69 6e | 66 6f 5b 22 64 62 74 79 |nect(cin|fo["dbty|
|00000530| 70 65 22 5d 2c 63 69 6e | 66 6f 5b 22 64 62 68 6f |pe"],cin|fo["dbho|
|00000540| 73 74 22 5d 2c 63 69 6e | 66 6f 5b 22 64 62 64 61 |st"],cin|fo["dbda|
|00000550| 74 61 62 61 73 65 22 5d | 2c 5c 0a 20 20 20 20 20 |tabase"]|,\.     |
|00000560| 20 63 69 6e 66 6f 5b 22 | 64 62 75 73 65 72 22 5d | cinfo["|dbuser"]|
|00000570| 2c 63 69 6e 66 6f 5b 22 | 64 62 70 61 73 73 77 6f |,cinfo["|dbpasswo|
|00000580| 72 64 22 5d 2c 33 2a 31 | 30 32 34 2c 63 69 6e 66 |rd"],3*1|024,cinf|
|00000590| 6f 5b 22 64 62 75 73 65 | 72 22 5d 2c 63 69 6e 66 |o["dbuse|r"],cinf|
|000005a0| 6f 5b 22 64 62 70 61 73 | 73 77 6f 72 64 22 5d 29 |o["dbpas|sword"])|
|000005b0| 20 69 6e 74 6f 20 64 62 | 72 65 73 75 6c 74 0a 20 | into db|result. |
|000005c0| 20 69 66 20 64 62 72 65 | 73 75 6c 74 20 69 73 20 | if dbre|sult is |
|000005d0| 61 20 6e 75 6d 62 65 72 | 20 74 68 65 6e 0a 20 20 |a number| then.  |
|000005e0| 20 20 70 75 74 20 64 62 | 72 65 73 75 6c 74 20 69 |  put db|result i|
|000005f0| 6e 74 6f 20 6e 65 77 63 | 6f 6e 6e 69 64 0a 20 20 |nto newc|onnid.  |
|00000600| 20 20 63 6c 6f 6e 65 20 | 73 74 61 63 6b 20 22 64 |  clone |stack "d|
|00000610| 61 74 61 63 6f 6e 6e 65 | 63 74 69 6f 6e 22 0a 20 |ataconne|ction". |
|00000620| 20 20 20 70 75 74 20 20 | 22 64 61 74 61 63 6f 6e |   put  |"datacon|
|00000630| 6e 65 63 74 69 6f 6e 2d | 22 26 6e 65 77 63 6f 6e |nection-|"&newcon|
|00000640| 6e 69 64 20 69 6e 74 6f | 20 6e 73 74 61 63 6b 6e |nid into| nstackn|
|00000650| 61 6d 65 0a 20 20 20 20 | 73 65 74 20 74 68 65 20 |ame.    |set the |
|00000660| 6e 61 6d 65 20 6f 66 20 | 74 68 65 20 74 6f 70 73 |name of |the tops|
|00000670| 74 61 63 6b 20 74 6f 20 | 6e 73 74 61 63 6b 6e 61 |tack to |nstackna|
|00000680| 6d 65 0a 20 20 20 20 73 | 65 74 20 74 68 65 20 6d |me.    s|et the m|
|00000690| 61 69 6e 73 74 61 63 6b | 20 6f 66 20 73 74 61 63 |ainstack| of stac|
|000006a0| 6b 20 6e 73 74 61 63 6b | 6e 61 6d 65 20 74 6f 20 |k nstack|name to |
|000006b0| 22 72 65 76 44 61 74 61 | 62 61 73 65 22 0a 20 20 |"revData|base".  |
|000006c0| 20 20 73 65 74 20 74 68 | 65 20 74 69 74 6c 65 20 |  set th|e title |
|000006d0| 6f 66 20 73 74 61 63 6b | 20 6e 73 74 61 63 6b 6e |of stack| nstackn|
|000006e0| 61 6d 65 20 74 6f 20 6e | 73 74 61 63 6b 6e 61 6d |ame to n|stacknam|
|000006f0| 65 0a 20 20 20 20 73 65 | 74 20 74 68 65 20 64 62 |e.    se|t the db|
|00000700| 63 6f 6e 6e 65 63 74 69 | 6f 6e 69 64 20 6f 66 20 |connecti|onid of |
|00000710| 73 74 61 63 6b 20 6e 73 | 74 61 63 6b 6e 61 6d 65 |stack ns|tackname|
|00000720| 20 74 6f 20 6e 65 77 63 | 6f 6e 6e 69 64 0a 20 20 | to newc|onnid.  |
|00000730| 20 20 73 65 74 20 74 68 | 65 20 62 61 63 6b 67 72 |  set th|e backgr|
|00000740| 6f 75 6e 64 63 6f 6c 6f | 72 20 6f 66 20 73 74 61 |oundcolo|r of sta|
|00000750| 63 6b 20 6e 73 74 61 63 | 6b 6e 61 6d 65 20 74 6f |ck nstac|kname to|
|00000760| 20 72 61 6e 64 63 6f 6c | 6f 72 28 29 0a 20 20 20 | randcol|or().   |
|00000770| 20 73 65 74 20 74 68 65 | 20 63 61 6e 74 4d 6f 64 | set the| cantMod|
|00000780| 69 66 79 20 6f 66 20 73 | 74 61 63 6b 20 6e 73 74 |ify of s|tack nst|
|00000790| 61 63 6b 6e 61 6d 65 20 | 74 6f 20 74 72 75 65 0a |ackname |to true.|
|000007a0| 20 20 65 6c 73 65 20 61 | 6e 73 77 65 72 20 64 62 |  else a|nswer db|
|000007b0| 72 65 73 75 6c 74 0a 65 | 6e 64 20 43 6f 6e 6e 65 |result.e|nd Conne|
|000007c0| 63 74 54 6f 44 61 74 61 | 62 61 73 65 0a 0a 6f 6e |ctToData|base..on|
|000007d0| 20 67 65 74 53 51 4c 50 | 61 72 61 6d 73 20 74 68 | getSQLP|arams th|
|000007e0| 65 71 75 65 72 79 2c 40 | 74 70 61 72 61 6d 73 0a |equery,@|tparams.|
|000007f0| 20 20 6c 6f 63 61 6c 20 | 74 68 65 6f 66 66 73 65 |  local |theoffse|
|00000800| 74 2c 62 69 6e 64 6e 75 | 6d 62 65 72 2c 62 69 6e |t,bindnu|mber,bin|
|00000810| 64 76 61 6c 75 65 2c 74 | 66 69 6c 65 6e 61 6d 65 |dvalue,t|filename|
|00000820| 0a 20 20 70 75 74 20 30 | 20 69 6e 74 6f 20 74 68 |.  put 0| into th|
|00000830| 65 6f 66 66 73 65 74 0a | 20 20 70 75 74 20 6f 66 |eoffset.|  put of|
|00000840| 66 73 65 74 28 22 3a 22 | 2c 74 68 65 71 75 65 72 |fset(":"|,thequer|
|00000850| 79 29 20 69 6e 74 6f 20 | 74 68 65 6f 66 66 73 65 |y) into |theoffse|
|00000860| 74 0a 20 20 72 65 70 65 | 61 74 20 77 68 69 6c 65 |t.  repe|at while|
|00000870| 20 74 68 65 6f 66 66 73 | 65 74 20 69 73 20 6e 6f | theoffs|et is no|
|00000880| 74 20 30 0a 20 20 20 20 | 70 75 74 20 63 68 61 72 |t 0.    |put char|
|00000890| 20 74 68 65 6f 66 66 73 | 65 74 2b 31 20 6f 66 20 | theoffs|et+1 of |
|000008a0| 74 68 65 71 75 65 72 79 | 20 69 6e 74 6f 20 62 69 |thequery| into bi|
|000008b0| 6e 64 6e 75 6d 62 65 72 | 0a 20 20 20 20 61 64 64 |ndnumber|.    add|
|000008c0| 20 31 20 74 6f 20 74 68 | 65 6f 66 66 73 65 74 0a | 1 to th|eoffset.|
|000008d0| 20 20 20 20 69 66 20 62 | 69 6e 64 6e 75 6d 62 65 |    if b|indnumbe|
|000008e0| 72 20 69 73 20 61 20 6e | 75 6d 62 65 72 20 74 68 |r is a n|umber th|
|000008f0| 65 6e 0a 20 20 20 20 20 | 20 69 66 20 74 70 61 72 |en.     | if tpar|
|00000900| 61 6d 73 5b 62 69 6e 64 | 6e 75 6d 62 65 72 5d 20 |ams[bind|number] |
|00000910| 69 73 20 65 6d 70 74 79 | 20 74 68 65 6e 0a 20 20 |is empty| then.  |
|00000920| 20 20 20 20 20 20 73 65 | 74 20 74 68 65 20 64 69 |      se|t the di|
|00000930| 61 6c 6f 67 64 61 74 61 | 20 74 6f 20 22 57 68 61 |alogdata| to "Wha|
|00000940| 74 20 69 73 20 74 68 65 | 20 76 61 6c 75 65 20 6f |t is the| value o|
|00000950| 66 20 22 26 26 22 3a 22 | 26 62 69 6e 64 6e 75 6d |f "&&":"|&bindnum|
|00000960| 62 65 72 0a 20 20 20 20 | 20 20 20 20 6d 6f 64 61 |ber.    |    moda|
|00000970| 6c 20 22 62 69 6e 64 64 | 69 61 6c 6f 67 22 0a 20 |l "bindd|ialog". |
|00000980| 20 20 20 20 20 20 20 70 | 75 74 20 74 68 65 20 64 |       p|ut the d|
|00000990| 69 61 6c 6f 67 64 61 74 | 61 20 69 6e 74 6f 20 62 |ialogdat|a into b|
|000009a0| 69 6e 64 76 61 6c 75 65 | 0a 20 20 20 20 20 20 20 |indvalue|.       |
|000009b0| 20 69 66 20 62 69 6e 64 | 76 61 6c 75 65 20 69 73 | if bind|value is|
|000009c0| 20 65 6d 70 74 79 20 74 | 68 65 6e 20 65 78 69 74 | empty t|hen exit|
|000009d0| 20 72 65 70 65 61 74 0a | 20 20 20 20 20 20 20 20 | repeat.|        |
|000009e0| 69 66 20 69 74 65 6d 20 | 31 20 6f 66 20 62 69 6e |if item |1 of bin|
|000009f0| 64 76 61 6c 75 65 20 69 | 73 20 22 75 73 65 66 69 |dvalue i|s "usefi|
|00000a00| 6c 65 22 20 74 68 65 6e | 0a 20 20 20 20 20 20 20 |le" then|.       |
|00000a10| 20 20 20 70 75 74 20 69 | 74 65 6d 20 32 20 6f 66 |   put i|tem 2 of|
|00000a20| 20 62 69 6e 64 76 61 6c | 75 65 20 69 6e 74 6f 20 | bindval|ue into |
|00000a30| 74 66 69 6c 65 6e 61 6d | 65 0a 20 20 20 20 20 20 |tfilenam|e.      |
|00000a40| 20 20 20 20 70 75 74 20 | 22 2a 62 22 26 75 72 6c |    put |"*b"&url|
|00000a50| 20 28 22 62 69 6e 66 69 | 6c 65 3a 22 26 74 66 69 | ("binfi|le:"&tfi|
|00000a60| 6c 65 6e 61 6d 65 29 20 | 69 6e 74 6f 20 74 70 61 |lename) |into tpa|
|00000a70| 72 61 6d 73 5b 62 69 6e | 64 6e 75 6d 62 65 72 5d |rams[bin|dnumber]|
|00000a80| 0a 20 20 20 20 20 20 20 | 20 65 6c 73 65 20 70 75 |.       | else pu|
|00000a90| 74 20 62 69 6e 64 76 61 | 6c 75 65 20 69 6e 74 6f |t bindva|lue into|
|00000aa0| 20 74 70 61 72 61 6d 73 | 5b 62 69 6e 64 6e 75 6d | tparams|[bindnum|
|00000ab0| 62 65 72 5d 0a 20 20 20 | 20 20 20 65 6e 64 20 69 |ber].   |   end i|
|00000ac0| 66 0a 20 20 20 20 65 6c | 73 65 20 65 78 69 74 20 |f.    el|se exit |
|00000ad0| 72 65 70 65 61 74 0a 20 | 20 20 20 67 65 74 20 6f |repeat. |   get o|
|00000ae0| 66 66 73 65 74 28 22 3a | 22 2c 74 68 65 71 75 65 |ffset(":|",theque|
|00000af0| 72 79 2c 74 68 65 6f 66 | 66 73 65 74 29 0a 20 20 |ry,theof|fset).  |
|00000b00| 20 20 69 66 20 69 74 20 | 69 73 20 30 20 74 68 65 |  if it |is 0 the|
|00000b10| 6e 20 65 78 69 74 20 72 | 65 70 65 61 74 0a 20 20 |n exit r|epeat.  |
|00000b20| 20 20 65 6c 73 65 20 70 | 75 74 20 69 74 2b 74 68 |  else p|ut it+th|
|00000b30| 65 6f 66 66 73 65 74 20 | 69 6e 74 6f 20 74 68 65 |eoffset |into the|
|00000b40| 6f 66 66 73 65 74 0a 20 | 20 65 6e 64 20 72 65 70 |offset. | end rep|
|00000b50| 65 61 74 0a 65 6e 64 20 | 67 65 74 53 51 4c 50 61 |eat.end |getSQLPa|
|00000b60| 72 61 6d 73 0a 0a 66 75 | 6e 63 74 69 6f 6e 20 64 |rams..fu|nction d|
|00000b70| 6f 71 75 65 72 79 20 74 | 68 65 63 6f 6e 6e 65 63 |oquery t|heconnec|
|00000b80| 74 69 6f 6e 2c 74 68 65 | 71 75 65 72 79 0a 20 20 |tion,the|query.  |
|00000b90| 6c 6f 63 61 6c 20 74 70 | 61 72 61 6d 73 2c 63 75 |local tp|arams,cu|
|00000ba0| 72 73 6f 72 69 64 2c 64 | 62 72 65 73 75 6c 74 2c |rsorid,d|bresult,|
|00000bb0| 6e 75 6d 63 6f 6c 75 6d | 6e 73 2c 6e 75 6d 72 6f |numcolum|ns,numro|
|00000bc0| 77 73 2c 72 6f 77 73 61 | 66 66 65 63 74 65 64 0a |ws,rowsa|ffected.|
|00000bd0| 20 20 67 65 74 53 51 4c | 50 61 72 61 6d 73 20 74 |  getSQL|Params t|
|00000be0| 68 65 71 75 65 72 79 2c | 74 70 61 72 61 6d 73 0a |hequery,|tparams.|
|00000bf0| 20 20 69 66 20 77 6f 72 | 64 20 31 20 6f 66 20 74 |  if wor|d 1 of t|
|00000c00| 68 65 71 75 65 72 79 20 | 69 73 20 61 6d 6f 6e 67 |hequery |is among|
|00000c10| 20 74 68 65 20 69 74 65 | 6d 73 20 6f 66 20 22 73 | the ite|ms of "s|
|00000c20| 65 6c 65 63 74 2c 73 68 | 6f 77 2c 64 65 73 63 72 |elect,sh|ow,descr|
|00000c30| 69 62 65 22 20 74 68 65 | 6e 0a 20 20 20 20 70 75 |ibe" the|n.    pu|
|00000c40| 74 20 72 65 76 64 62 5f | 71 75 65 72 79 28 74 68 |t revdb_|query(th|
|00000c50| 65 63 6f 6e 6e 65 63 74 | 69 6f 6e 2c 74 68 65 71 |econnect|ion,theq|
|00000c60| 75 65 72 79 2c 22 74 70 | 61 72 61 6d 73 22 29 20 |uery,"tp|arams") |
|00000c70| 69 6e 74 6f 20 64 62 72 | 65 73 75 6c 74 0a 20 20 |into dbr|esult.  |
|00000c80| 20 20 69 66 20 64 62 72 | 65 73 75 6c 74 20 69 73 |  if dbr|esult is|
|00000c90| 20 6e 6f 74 20 61 20 6e | 75 6d 62 65 72 20 74 68 | not a n|umber th|
|00000ca0| 65 6e 20 72 65 74 75 72 | 6e 20 64 62 72 65 73 75 |en retur|n dbresu|
|00000cb0| 6c 74 0a 20 20 20 20 65 | 6c 73 65 0a 20 20 20 20 |lt.    e|lse.    |
|00000cc0| 20 20 70 75 74 20 64 62 | 72 65 73 75 6c 74 20 69 |  put db|result i|
|00000cd0| 6e 74 6f 20 63 75 72 73 | 6f 72 69 64 0a 20 20 20 |nto curs|orid.   |
|00000ce0| 20 20 20 70 75 74 20 72 | 65 76 64 62 5f 72 65 63 |   put r|evdb_rec|
|00000cf0| 6f 72 64 63 6f 75 6e 74 | 28 63 75 72 73 6f 72 69 |ordcount|(cursori|
|00000d00| 64 29 20 69 6e 74 6f 20 | 6e 75 6d 72 6f 77 73 0a |d) into |numrows.|
|00000d10| 20 20 20 20 20 20 70 75 | 74 20 72 65 76 64 62 5f |      pu|t revdb_|
|00000d20| 63 6f 6c 75 6d 6e 63 6f | 75 6e 74 28 63 75 72 73 |columnco|unt(curs|
|00000d30| 6f 72 69 64 29 20 69 6e | 74 6f 20 6e 75 6d 63 6f |orid) in|to numco|
|00000d40| 6c 75 6d 6e 73 0a 20 20 | 20 20 20 20 70 75 74 20 |lumns.  |    put |
|00000d50| 72 65 76 64 62 5f 63 6f | 6c 75 6d 6e 74 79 70 65 |revdb_co|lumntype|
|00000d60| 73 28 63 75 72 73 6f 72 | 69 64 29 20 69 6e 74 6f |s(cursor|id) into|
|00000d70| 20 63 6f 6c 74 79 70 65 | 73 0a 20 20 20 20 20 20 | coltype|s.      |
|00000d80| 64 69 73 70 6c 61 79 72 | 65 73 75 6c 74 73 65 74 |displayr|esultset|
|00000d90| 20 63 75 72 73 6f 72 69 | 64 0a 20 20 20 20 20 20 | cursori|d.      |
|00000da0| 69 66 20 30 20 3e 20 6e | 75 6d 72 6f 77 73 20 74 |if 0 > n|umrows t|
|00000db0| 68 65 6e 20 70 75 74 20 | 74 68 65 20 72 65 73 75 |hen put |the resu|
|00000dc0| 6c 74 20 69 6e 74 6f 20 | 6e 75 6d 72 6f 77 73 0a |lt into |numrows.|
|00000dd0| 20 20 20 20 20 20 72 65 | 74 75 72 6e 20 22 51 75 |      re|turn "Qu|
|00000de0| 65 72 79 20 4f 4b 2e 20 | 4e 65 77 20 52 65 73 75 |ery OK. |New Resu|
|00000df0| 6c 74 53 65 74 20 49 44 | 20 22 26 26 63 75 72 73 |ltSet ID| "&&curs|
|00000e00| 6f 72 69 64 26 26 22 63 | 72 65 61 74 65 64 2e 22 |orid&&"c|reated."|
|00000e10| 26 63 72 26 20 5c 0a 20 | 20 20 20 20 20 20 20 20 |&cr& \. |        |
|00000e20| 20 22 4e 75 6d 62 65 72 | 20 6f 72 20 72 6f 77 73 | "Number| or rows|
|00000e30| 20 72 65 74 72 69 65 76 | 65 64 3a 22 26 6e 75 6d | retriev|ed:"&num|
|00000e40| 72 6f 77 73 26 26 22 4e | 75 6d 62 65 72 20 6f 66 |rows&&"N|umber of|
|00000e50| 20 63 6f 6c 75 6d 6e 73 | 3a 22 26 26 6e 75 6d 63 | columns|:"&&numc|
|00000e60| 6f 6c 75 6d 6e 73 20 26 | 20 63 72 26 20 5c 0a 20 |olumns &| cr& \. |
|00000e70| 20 20 20 20 20 20 20 20 | 20 22 63 6f 6c 75 6d 6e |        | "column|
|00000e80| 20 74 79 70 65 73 3a 22 | 26 63 6f 6c 74 79 70 65 | types:"|&coltype|
|00000e90| 73 0a 20 20 20 20 65 6e | 64 20 69 66 0a 20 20 65 |s.    en|d if.  e|
|00000ea0| 6c 73 65 0a 20 20 20 20 | 70 75 74 20 72 65 76 64 |lse.    |put revd|
|00000eb0| 62 5f 65 78 65 63 75 74 | 65 28 74 68 65 63 6f 6e |b_execut|e(thecon|
|00000ec0| 6e 65 63 74 69 6f 6e 2c | 74 68 65 71 75 65 72 79 |nection,|thequery|
|00000ed0| 2c 22 74 70 61 72 61 6d | 73 22 29 20 69 6e 74 6f |,"tparam|s") into|
|00000ee0| 20 64 62 72 65 73 75 6c | 74 0a 20 20 20 20 69 66 | dbresul|t.    if|
|00000ef0| 20 64 62 72 65 73 75 6c | 74 20 69 73 20 61 20 6e | dbresul|t is a n|
|00000f00| 75 6d 62 65 72 20 74 68 | 65 6e 0a 20 20 20 20 20 |umber th|en.     |
|00000f10| 20 70 75 74 20 64 62 72 | 65 73 75 6c 74 20 69 6e | put dbr|esult in|
|00000f20| 74 6f 20 72 6f 77 73 61 | 66 66 65 63 74 65 64 0a |to rowsa|ffected.|
|00000f30| 20 20 20 20 20 20 70 75 | 74 20 22 51 75 65 72 79 |      pu|t "Query|
|00000f40| 20 4f 4b 2e 22 26 63 72 | 26 22 4e 75 6d 62 65 72 | OK."&cr|&"Number|
|00000f50| 20 6f 66 20 72 6f 77 73 | 20 61 66 66 65 63 74 65 | of rows| affecte|
|00000f60| 64 3a 22 26 26 72 6f 77 | 73 61 66 66 65 63 74 65 |d:"&&row|saffecte|
|00000f70| 64 20 69 6e 74 6f 20 74 | 72 65 73 75 6c 74 0a 20 |d into t|result. |
|00000f80| 20 20 20 20 20 67 65 74 | 20 72 65 76 64 62 5f 63 |     get| revdb_c|
|00000f90| 6f 6d 6d 69 74 28 74 68 | 65 63 6f 6e 6e 65 63 74 |ommit(th|econnect|
|00000fa0| 69 6f 6e 29 0a 20 20 20 | 20 65 6c 73 65 20 70 75 |ion).   | else pu|
|00000fb0| 74 20 64 62 72 65 73 75 | 6c 74 20 69 6e 74 6f 20 |t dbresu|lt into |
|00000fc0| 74 72 65 73 75 6c 74 0a | 20 20 65 6e 64 20 69 66 |tresult.|  end if|
|00000fd0| 0a 20 20 72 65 74 75 72 | 6e 20 74 72 65 73 75 6c |.  retur|n tresul|
|00000fe0| 74 0a 65 6e 64 20 64 6f | 71 75 65 72 79 0a 0a 6f |t.end do|query..o|
|00000ff0| 6e 20 63 6c 6f 73 65 64 | 61 74 61 63 6f 6e 6e 65 |n closed|ataconne|
|00001000| 63 74 69 6f 6e 20 64 62 | 63 6f 6e 6e 65 63 74 69 |ction db|connecti|
|00001010| 6f 6e 0a 20 20 70 75 74 | 20 72 65 76 64 62 5f 63 |on.  put| revdb_c|
|00001020| 75 72 73 6f 72 73 28 64 | 62 63 6f 6e 6e 65 63 74 |ursors(d|bconnect|
|00001030| 69 6f 6e 29 20 69 6e 74 | 6f 20 63 75 72 73 6f 72 |ion) int|o cursor|
|00001040| 6c 69 73 74 0a 20 20 69 | 66 20 69 74 65 6d 20 31 |list.  i|f item 1|
|00001050| 20 6f 66 20 63 75 72 73 | 6f 72 6c 69 73 74 20 69 | of curs|orlist i|
|00001060| 73 20 6e 6f 74 20 22 72 | 65 76 64 62 65 72 72 22 |s not "r|evdberr"|
|00001070| 20 74 68 65 6e 0a 20 20 | 20 20 72 65 70 65 61 74 | then.  |  repeat|
|00001080| 20 66 6f 72 20 65 61 63 | 68 20 69 74 65 6d 20 69 | for eac|h item i|
|00001090| 20 69 6e 20 63 75 72 73 | 6f 72 6c 69 73 74 0a 20 | in curs|orlist. |
|000010a0| 20 20 20 20 20 64 65 6c | 65 74 65 20 73 74 61 63 |     del|ete stac|
|000010b0| 6b 20 28 22 64 61 74 61 | 72 65 73 75 6c 74 2d 22 |k ("data|result-"|
|000010c0| 26 69 29 0a 20 20 20 20 | 65 6e 64 20 72 65 70 65 |&i).    |end repe|
|000010d0| 61 74 0a 20 20 65 6e 64 | 20 69 66 0a 20 20 70 75 |at.  end| if.  pu|
|000010e0| 74 20 72 65 76 64 62 5f | 64 69 73 63 6f 6e 6e 65 |t revdb_|disconne|
|000010f0| 63 74 28 64 62 63 6f 6e | 6e 65 63 74 69 6f 6e 29 |ct(dbcon|nection)|
|00001100| 20 69 6e 74 6f 20 64 62 | 72 65 73 75 6c 74 0a 65 | into db|result.e|
|00001110| 6e 64 20 63 6c 6f 73 65 | 64 61 74 61 63 6f 6e 6e |nd close|dataconn|
|00001120| 65 63 74 69 6f 6e 0a 0a | 6f 6e 20 63 6c 6f 73 65 |ection..|on close|
|00001130| 63 75 72 73 6f 72 63 6f | 6e 6e 65 63 74 69 6f 6e |cursorco|nnection|
|00001140| 20 64 62 63 75 72 73 6f | 72 0a 20 20 70 75 74 20 | dbcurso|r.  put |
|00001150| 72 65 76 64 62 5f 63 6c | 6f 73 65 63 75 72 73 6f |revdb_cl|osecurso|
|00001160| 72 28 64 62 63 75 72 73 | 6f 72 29 20 69 6e 74 6f |r(dbcurs|or) into|
|00001170| 20 64 62 72 65 73 75 6c | 74 0a 65 6e 64 20 63 6c | dbresul|t.end cl|
|00001180| 6f 73 65 63 75 72 73 6f | 72 63 6f 6e 6e 65 63 74 |osecurso|rconnect|
|00001190| 69 6f 6e 0a 0a 6f 6e 20 | 70 72 65 4f 70 65 6e 53 |ion..on |preOpenS|
|000011a0| 74 61 63 6b 0a 20 20 73 | 65 74 20 74 68 65 20 6d |tack.  s|et the m|
|000011b0| 69 6e 57 69 64 74 68 20 | 6f 66 20 74 68 69 73 20 |inWidth |of this |
|000011c0| 73 74 61 63 6b 20 74 6f | 20 34 30 32 0a 20 20 73 |stack to| 402.  s|
|000011d0| 65 74 20 74 68 65 20 6d | 61 78 57 69 64 74 68 20 |et the m|axWidth |
|000011e0| 6f 66 20 74 68 69 73 20 | 73 74 61 63 6b 20 74 6f |of this |stack to|
|000011f0| 20 34 30 32 0a 65 6e 64 | 20 70 72 65 4f 70 65 6e | 402.end| preOpen|
|00001200| 53 74 61 63 6b 0a 0a 6f | 6e 20 6f 70 65 6e 53 74 |Stack..o|n openSt|
|00001210| 61 63 6b 0a 20 20 69 66 | 20 74 68 65 20 70 6c 61 |ack.  if| the pla|
|00001220| 74 66 6f 72 6d 20 69 73 | 20 22 4d 61 63 4f 53 22 |tform is| "MacOS"|
|00001230| 20 61 6e 64 20 63 68 61 | 72 20 31 20 6f 66 20 74 | and cha|r 1 of t|
|00001240| 68 65 20 73 79 73 74 65 | 6d 56 65 72 73 69 6f 6e |he syste|mVersion|
|00001250| 20 69 73 20 22 31 22 20 | 74 68 65 6e 0a 20 20 20 | is "1" |then.   |
|00001260| 20 61 6e 73 77 65 72 20 | 65 72 72 6f 72 20 22 4f | answer |error "O|
|00001270| 6e 6c 79 20 4d 79 53 51 | 4c 20 61 6e 64 20 56 61 |nly MySQ|L and Va|
|00001280| 6c 65 6e 74 69 6e 61 20 | 64 61 74 61 62 61 73 65 |lentina |database|
|00001290| 73 20 61 72 65 20 63 75 | 72 72 65 6e 74 6c 79 20 |s are cu|rrently |
|000012a0| 73 75 70 70 6f 72 74 65 | 64 20 6f 6e 20 4f 53 20 |supporte|d on OS |
|000012b0| 58 20 64 75 65 20 74 6f | 20 64 72 69 76 65 72 20 |X due to| driver |
|000012c0| 69 73 73 75 65 73 2e 22 | 20 77 69 74 68 20 22 4f |issues."| with "O|
|000012d0| 4b 22 0a 20 20 65 6e 64 | 20 69 66 0a 65 6e 64 20 |K".  end| if.end |
|000012e0| 6f 70 65 6e 53 74 61 63 | 6b 0a 0a 6f 6e 20 70 72 |openStac|k..on pr|
|000012f0| 65 4f 70 65 6e 43 61 72 | 64 0a 20 20 70 75 74 20 |eOpenCar|d.  put |
|00001300| 74 68 65 20 72 65 63 74 | 20 6f 66 20 74 68 69 73 |the rect| of this|
|00001310| 20 73 74 61 63 6b 20 69 | 6e 74 6f 20 74 52 65 63 | stack i|nto tRec|
|00001320| 74 0a 20 20 73 65 74 20 | 74 68 65 20 72 65 63 74 |t.  set |the rect|
|00001330| 20 6f 66 20 74 68 69 73 | 20 73 74 61 63 6b 20 74 | of this| stack t|
|00001340| 6f 20 69 74 65 6d 20 31 | 20 74 6f 20 33 20 6f 66 |o item 1| to 3 of|
|00001350| 20 74 52 65 63 74 2c 69 | 74 65 6d 20 32 20 6f 66 | tRect,i|tem 2 of|
|00001360| 20 74 52 65 63 74 20 2b | 20 74 68 65 20 63 52 45 | tRect +| the cRE|
|00001370| 56 4d 69 6e 48 65 69 67 | 68 74 20 6f 66 20 74 68 |VMinHeig|ht of th|
|00001380| 69 73 20 63 64 0a 65 6e | 64 20 70 72 65 4f 70 65 |is cd.en|d preOpe|
|00001390| 6e 43 61 72 64 0a 0a 6f | 6e 20 63 6c 6f 73 65 63 |nCard..o|n closec|
|000013a0| 6f 6e 6e 65 63 74 69 6f | 6e 73 0a 20 20 70 75 74 |onnectio|ns.  put|
|000013b0| 20 72 65 76 64 62 5f 63 | 6f 6e 6e 65 63 74 69 6f | revdb_c|onnectio|
|000013c0| 6e 73 28 29 20 69 6e 74 | 6f 20 63 6f 6e 6e 65 63 |ns() int|o connec|
|000013d0| 74 69 6f 6e 6c 69 73 74 | 0a 20 20 72 65 70 65 61 |tionlist|.  repea|
|000013e0| 74 20 66 6f 72 20 65 61 | 63 68 20 69 74 65 6d 20 |t for ea|ch item |
|000013f0| 69 20 69 6e 20 63 6f 6e | 6e 65 63 74 69 6f 6e 6c |i in con|nectionl|
|00001400| 69 73 74 0a 20 20 20 20 | 64 65 6c 65 74 65 20 73 |ist.    |delete s|
|00001410| 74 61 63 6b 20 28 22 64 | 61 74 61 63 6f 6e 6e 65 |tack ("d|ataconne|
|00001420| 63 74 69 6f 6e 2d 22 26 | 69 29 0a 20 20 65 6e 64 |ction-"&|i).  end|
|00001430| 20 72 65 70 65 61 74 0a | 65 6e 64 20 63 6c 6f 73 | repeat.|end clos|
|00001440| 65 63 6f 6e 6e 65 63 74 | 69 6f 6e 73 0a 0a 6f 6e |econnect|ions..on|
|00001450| 20 64 69 73 70 6c 61 79 | 72 65 73 75 6c 74 73 65 | display|resultse|
|00001460| 74 20 63 75 72 73 6f 72 | 69 64 0a 20 20 6c 6f 63 |t cursor|id.  loc|
|00001470| 61 6c 20 63 6f 6c 6e 61 | 6d 65 73 2c 63 6f 6c 6c |al colna|mes,coll|
|00001480| 65 6e 67 74 68 73 2c 74 | 69 74 6c 65 73 65 70 2c |engths,t|itlesep,|
|00001490| 63 6f 6c 63 6f 75 6e 74 | 2c 72 65 73 75 6c 74 64 |colcount|,resultd|
|000014a0| 61 74 61 0a 20 20 62 72 | 65 61 6b 70 6f 69 6e 74 |ata.  br|eakpoint|
|000014b0| 0a 20 20 70 75 74 20 72 | 65 76 64 62 5f 63 6f 6c |.  put r|evdb_col|
|000014c0| 75 6d 6e 6e 61 6d 65 73 | 28 63 75 72 73 6f 72 69 |umnnames|(cursori|
|000014d0| 64 29 20 69 6e 74 6f 20 | 63 6f 6c 6e 61 6d 65 73 |d) into |colnames|
|000014e0| 0a 20 20 70 75 74 20 6e | 75 6d 62 65 72 20 6f 66 |.  put n|umber of|
|000014f0| 20 69 74 65 6d 73 20 6f | 66 20 63 6f 6c 6e 61 6d | items o|f colnam|
|00001500| 65 73 20 69 6e 74 6f 20 | 63 6f 6c 63 6f 75 6e 74 |es into |colcount|
|00001510| 0a 20 20 70 75 74 20 72 | 65 76 64 62 5f 63 6f 6c |.  put r|evdb_col|
|00001520| 75 6d 6e 6c 65 6e 67 74 | 68 73 28 63 75 72 73 6f |umnlengt|hs(curso|
|00001530| 72 69 64 29 20 69 6e 74 | 6f 20 63 6f 6c 6c 65 6e |rid) int|o collen|
|00001540| 67 74 68 73 0a 20 20 73 | 70 6c 69 74 20 63 6f 6c |gths.  s|plit col|
|00001550| 6e 61 6d 65 73 20 62 79 | 20 63 6f 6d 6d 61 0a 20 |names by| comma. |
|00001560| 20 73 70 6c 69 74 20 63 | 6f 6c 6c 65 6e 67 74 68 | split c|ollength|
|00001570| 73 20 62 79 20 63 6f 6d | 6d 61 0a 20 20 72 65 70 |s by com|ma.  rep|
|00001580| 65 61 74 20 77 69 74 68 | 20 69 20 3d 20 31 20 74 |eat with| i = 1 t|
|00001590| 6f 20 63 6f 6c 63 6f 75 | 6e 74 20 2d 2d 74 72 75 |o colcou|nt --tru|
|000015a0| 6e 63 61 74 65 20 63 6f | 6c 75 6d 6e 20 6c 65 6e |ncate co|lumn len|
|000015b0| 67 74 68 73 20 69 6e 20 | 63 61 73 65 20 6f 66 20 |gths in |case of |
|000015c0| 6c 61 72 67 65 20 76 61 | 6c 75 65 73 0a 20 20 20 |large va|lues.   |
|000015d0| 20 69 66 20 63 6f 6c 6c | 65 6e 67 74 68 73 5b 69 | if coll|engths[i|
|000015e0| 5d 20 3e 20 33 30 20 74 | 68 65 6e 20 70 75 74 20 |] > 30 t|hen put |
|000015f0| 33 30 20 69 6e 74 6f 20 | 63 6f 6c 6c 65 6e 67 74 |30 into |collengt|
|00001600| 68 73 5b 69 5d 0a 20 20 | 20 20 61 64 64 20 35 20 |hs[i].  |  add 5 |
|00001610| 74 6f 20 63 6f 6c 6c 65 | 6e 67 74 68 73 5b 69 5d |to colle|ngths[i]|
|00001620| 20 2d 2d 20 61 64 64 20 | 61 20 6c 69 74 74 6c 65 | -- add |a little|
|00001630| 20 65 78 74 72 61 20 70 | 61 64 64 69 6e 67 0a 20 | extra p|adding. |
|00001640| 20 65 6e 64 20 72 65 70 | 65 61 74 0a 20 20 72 65 | end rep|eat.  re|
|00001650| 70 65 61 74 20 77 69 74 | 68 20 69 20 3d 20 31 20 |peat wit|h i = 1 |
|00001660| 74 6f 20 63 6f 6c 63 6f | 75 6e 74 0a 20 20 20 20 |to colco|unt.    |
|00001670| 70 75 74 20 66 6f 72 6d | 61 74 28 22 25 2d 22 26 |put form|at("%-"&|
|00001680| 63 6f 6c 6c 65 6e 67 74 | 68 73 5b 69 5d 26 22 2e |collengt|hs[i]&".|
|00001690| 33 30 73 22 2c 74 6f 55 | 70 70 65 72 28 63 6f 6c |30s",toU|pper(col|
|000016a0| 6e 61 6d 65 73 5b 69 5d | 29 29 20 61 66 74 65 72 |names[i]|)) after|
|000016b0| 20 72 65 73 75 6c 74 64 | 61 74 61 0a 20 20 65 6e | resultd|ata.  en|
|000016c0| 64 20 72 65 70 65 61 74 | 0a 20 20 70 75 74 20 72 |d repeat|.  put r|
|000016d0| 65 74 75 72 6e 20 61 66 | 74 65 72 20 72 65 73 75 |eturn af|ter resu|
|000016e0| 6c 74 64 61 74 61 0a 20 | 20 72 65 70 65 61 74 20 |ltdata. | repeat |
|000016f0| 77 69 74 68 20 69 20 3d | 20 31 20 74 6f 20 33 32 |with i =| 1 to 32|
|00001700| 0a 20 20 20 20 70 75 74 | 20 22 2d 22 20 61 66 74 |.    put| "-" aft|
|00001710| 65 72 20 74 69 74 6c 65 | 73 65 70 0a 20 20 65 6e |er title|sep.  en|
|00001720| 64 20 72 65 70 65 61 74 | 0a 20 20 72 65 70 65 61 |d repeat|.  repea|
|00001730| 74 20 77 69 74 68 20 69 | 20 3d 20 31 20 74 6f 20 |t with i| = 1 to |
|00001740| 63 6f 6c 63 6f 75 6e 74 | 0a 20 20 20 20 70 75 74 |colcount|.    put|
|00001750| 20 63 68 61 72 20 31 20 | 74 6f 20 63 6f 6c 6c 65 | char 1 |to colle|
|00001760| 6e 67 74 68 73 5b 69 5d | 20 6f 66 20 74 69 74 6c |ngths[i]| of titl|
|00001770| 65 73 65 70 20 61 66 74 | 65 72 20 72 65 73 75 6c |esep aft|er resul|
|00001780| 74 64 61 74 61 0a 20 20 | 65 6e 64 20 72 65 70 65 |tdata.  |end repe|
|00001790| 61 74 0a 20 20 70 75 74 | 20 30 20 69 6e 74 6f 20 |at.  put| 0 into |
|000017a0| 72 6f 77 73 72 65 74 72 | 69 65 76 65 64 0a 20 20 |rowsretr|ieved.  |
|000017b0| 72 65 70 65 61 74 20 77 | 68 69 6c 65 20 72 65 76 |repeat w|hile rev|
|000017c0| 64 62 5f 69 73 65 6f 66 | 28 63 75 72 73 6f 72 69 |db_iseof|(cursori|
|000017d0| 64 29 20 69 73 20 6e 6f | 74 20 74 72 75 65 0a 20 |d) is no|t true. |
|000017e0| 20 20 20 61 64 64 20 31 | 20 74 6f 20 72 6f 77 73 |   add 1| to rows|
|000017f0| 72 65 74 72 69 65 76 65 | 64 0a 20 20 20 20 70 75 |retrieve|d.    pu|
|00001800| 74 20 72 65 74 75 72 6e | 20 61 66 74 65 72 20 72 |t return| after r|
|00001810| 65 73 75 6c 74 64 61 74 | 61 0a 20 20 20 20 72 65 |esultdat|a.    re|
|00001820| 70 65 61 74 20 77 69 74 | 68 20 69 20 3d 20 31 20 |peat wit|h i = 1 |
|00001830| 74 6f 20 63 6f 6c 63 6f | 75 6e 74 0a 20 20 20 20 |to colco|unt.    |
|00001840| 20 20 69 66 20 72 65 76 | 64 62 5f 63 6f 6c 75 6d |  if rev|db_colum|
|00001850| 6e 69 73 6e 75 6c 6c 28 | 63 75 72 73 6f 72 69 64 |nisnull(|cursorid|
|00001860| 2c 69 29 20 69 73 20 74 | 72 75 65 20 74 68 65 6e |,i) is t|rue then|
|00001870| 20 70 75 74 20 66 6f 72 | 6d 61 74 28 22 25 2d 22 | put for|mat("%-"|
|00001880| 26 63 6f 6c 6c 65 6e 67 | 74 68 73 5b 69 5d 26 22 |&colleng|ths[i]&"|
|00001890| 2e 33 30 73 22 2c 22 4e | 55 4c 4c 22 29 20 61 66 |.30s","N|ULL") af|
|000018a0| 74 65 72 20 72 65 73 75 | 6c 74 64 61 74 61 0a 20 |ter resu|ltdata. |
|000018b0| 20 20 20 20 20 65 6c 73 | 65 20 70 75 74 20 66 6f |     els|e put fo|
|000018c0| 72 6d 61 74 28 22 25 2d | 22 26 63 6f 6c 6c 65 6e |rmat("%-|"&collen|
|000018d0| 67 74 68 73 5b 69 5d 26 | 22 2e 33 30 73 22 2c 72 |gths[i]&|".30s",r|
|000018e0| 65 76 64 62 5f 63 6f 6c | 75 6d 6e 62 79 6e 75 6d |evdb_col|umnbynum|
|000018f0| 62 65 72 28 63 75 72 73 | 6f 72 69 64 2c 69 29 29 |ber(curs|orid,i))|
|00001900| 20 61 66 74 65 72 20 72 | 65 73 75 6c 74 64 61 74 | after r|esultdat|
|00001910| 61 0a 20 20 20 20 65 6e | 64 20 72 65 70 65 61 74 |a.    en|d repeat|
|00001920| 0a 20 20 20 20 67 65 74 | 20 72 65 76 64 62 5f 6d |.    get| revdb_m|
|00001930| 6f 76 65 6e 65 78 74 28 | 63 75 72 73 6f 72 69 64 |ovenext(|cursorid|
|00001940| 29 0a 20 20 65 6e 64 20 | 72 65 70 65 61 74 0a 20 |).  end |repeat. |
|00001950| 20 63 6c 6f 6e 65 20 73 | 74 61 63 6b 20 22 64 61 | clone s|tack "da|
|00001960| 74 61 72 65 73 75 6c 74 | 22 0a 20 20 70 75 74 20 |taresult|".  put |
|00001970| 22 64 61 74 61 72 65 73 | 75 6c 74 2d 22 26 63 75 |"datares|ult-"&cu|
|00001980| 72 73 6f 72 69 64 20 69 | 6e 74 6f 20 6e 73 74 61 |rsorid i|nto nsta|
|00001990| 63 6b 6e 61 6d 65 0a 20 | 20 73 65 74 20 74 68 65 |ckname. | set the|
|000019a0| 20 6e 61 6d 65 20 6f 66 | 20 74 68 65 20 74 6f 70 | name of| the top|
|000019b0| 73 74 61 63 6b 20 74 6f | 20 6e 73 74 61 63 6b 6e |stack to| nstackn|
|000019c0| 61 6d 65 0a 20 20 73 65 | 74 20 74 68 65 20 6d 61 |ame.  se|t the ma|
|000019d0| 69 6e 73 74 61 63 6b 20 | 6f 66 20 73 74 61 63 6b |instack |of stack|
|000019e0| 20 6e 73 74 61 63 6b 6e | 61 6d 65 20 74 6f 20 22 | nstackn|ame to "|
|000019f0| 72 65 76 64 61 74 61 62 | 61 73 65 22 0a 20 20 73 |revdatab|ase".  s|
|00001a00| 65 74 20 74 68 65 20 74 | 69 74 6c 65 20 6f 66 20 |et the t|itle of |
|00001a10| 73 74 61 63 6b 20 6e 73 | 74 61 63 6b 6e 61 6d 65 |stack ns|tackname|
|00001a20| 20 74 6f 20 6e 73 74 61 | 63 6b 6e 61 6d 65 0a 20 | to nsta|ckname. |
|00001a30| 20 73 65 74 20 74 68 65 | 20 63 61 6e 74 4d 6f 64 | set the| cantMod|
|00001a40| 69 66 79 20 6f 66 20 73 | 74 61 63 6b 20 6e 73 74 |ify of s|tack nst|
|00001a50| 61 63 6b 6e 61 6d 65 20 | 74 6f 20 74 72 75 65 0a |ackname |to true.|
|00001a60| 20 20 73 65 74 20 74 68 | 65 20 64 62 63 75 72 73 |  set th|e dbcurs|
|00001a70| 6f 72 69 64 20 6f 66 20 | 73 74 61 63 6b 20 6e 73 |orid of |stack ns|
|00001a80| 74 61 63 6b 6e 61 6d 65 | 20 74 6f 20 63 75 72 73 |tackname| to curs|
|00001a90| 6f 72 69 64 0a 20 20 70 | 75 74 20 72 65 73 75 6c |orid.  p|ut resul|
|00001aa0| 74 64 61 74 61 20 69 6e | 74 6f 20 66 69 65 6c 64 |tdata in|to field|
|00001ab0| 20 22 44 42 52 45 53 55 | 4c 54 44 41 54 41 22 20 | "DBRESU|LTDATA" |
|00001ac0| 6f 66 20 73 74 61 63 6b | 20 6e 73 74 61 63 6b 6e |of stack| nstackn|
|00001ad0| 61 6d 65 0a 20 20 73 65 | 74 20 74 68 65 20 62 61 |ame.  se|t the ba|
|00001ae0| 63 6b 67 72 6f 75 6e 64 | 63 6f 6c 6f 72 20 6f 66 |ckground|color of|
|00001af0| 20 73 74 61 63 6b 20 6e | 73 74 61 63 6b 6e 61 6d | stack n|stacknam|
|00001b00| 65 20 74 6f 20 74 68 65 | 20 62 61 63 6b 67 72 6f |e to the| backgro|
|00001b10| 75 6e 64 63 6f 6c 6f 72 | 20 5c 0a 20 20 20 20 20 |undcolor| \.     |
|00001b20| 20 6f 66 20 73 74 61 63 | 6b 20 28 22 64 61 74 61 | of stac|k ("data|
|00001b30| 63 6f 6e 6e 65 63 74 69 | 6f 6e 2d 22 26 72 65 76 |connecti|on-"&rev|
|00001b40| 64 62 5f 63 75 72 73 6f | 72 63 6f 6e 6e 65 63 74 |db_curso|rconnect|
|00001b50| 69 6f 6e 28 63 75 72 73 | 6f 72 69 64 29 20 29 0a |ion(curs|orid) ).|
|00001b60| 20 20 20 20 20 20 72 65 | 74 75 72 6e 20 72 6f 77 |      re|turn row|
|00001b70| 73 72 65 74 72 69 65 76 | 65 64 0a 65 6e 64 20 64 |sretriev|ed.end d|
|00001b80| 69 73 70 6c 61 79 72 65 | 73 75 6c 74 73 65 74 0a |isplayre|sultset.|
|00001b90| 0a 6c 6f 63 61 6c 20 72 | 61 6e 64 63 6f 6c 6f 72 |.local r|andcolor|
|00001ba0| 63 6f 75 6e 74 20 3d 20 | 30 0a 66 75 6e 63 74 69 |count = |0.functi|
|00001bb0| 6f 6e 20 72 61 6e 64 63 | 6f 6c 6f 72 0a 20 20 69 |on randc|olor.  i|
|00001bc0| 66 20 72 61 6e 64 63 6f | 6c 6f 72 63 6f 75 6e 74 |f randco|lorcount|
|00001bd0| 20 69 73 20 38 20 74 68 | 65 6e 20 70 75 74 20 30 | is 8 th|en put 0|
|00001be0| 20 69 6e 74 6f 20 72 61 | 6e 64 63 6f 6c 6f 72 63 | into ra|ndcolorc|
|00001bf0| 6f 75 6e 74 0a 20 20 61 | 64 64 20 31 20 74 6f 20 |ount.  a|dd 1 to |
|00001c00| 72 61 6e 64 63 6f 6c 6f | 72 63 6f 75 6e 74 0a 20 |randcolo|rcount. |
|00001c10| 20 72 65 74 75 72 6e 20 | 6c 69 6e 65 20 72 61 6e | return |line ran|
|00001c20| 64 63 6f 6c 6f 72 63 6f | 75 6e 74 20 6f 66 20 74 |dcolorco|unt of t|
|00001c30| 68 65 20 63 6f 6c 6f 72 | 6c 69 73 74 20 6f 66 20 |he color|list of |
|00001c40| 74 68 69 73 20 73 74 61 | 63 6b 0a 65 6e 64 20 72 |this sta|ck.end r|
|00001c50| 61 6e 64 63 6f 6c 6f 72 | 0a 0a 6f 6e 20 6f 70 65 |andcolor|..on ope|
|00001c60| 6e 53 74 61 63 6b 0a 20 | 20 69 66 20 74 68 65 20 |nStack. | if the |
|00001c70| 70 6c 61 74 66 6f 72 6d | 20 69 73 20 22 4d 61 63 |platform| is "Mac|
|00001c80| 4f 53 22 20 61 6e 64 20 | 63 68 61 72 20 31 20 6f |OS" and |char 1 o|
|00001c90| 66 20 74 68 65 20 73 79 | 73 74 65 6d 56 65 72 73 |f the sy|stemVers|
|00001ca0| 69 6f 6e 20 69 73 20 22 | 31 22 20 74 68 65 6e 0a |ion is "|1" then.|
|00001cb0| 20 20 20 20 61 6e 73 77 | 65 72 20 65 72 72 6f 72 |    answ|er error|
|00001cc0| 20 22 4f 6e 6c 79 20 4d | 79 53 51 4c 20 61 6e 64 | "Only M|ySQL and|
|00001cd0| 20 56 61 6c 65 6e 74 69 | 6e 61 20 64 61 74 61 62 | Valenti|na datab|
|00001ce0| 61 73 65 73 20 61 72 65 | 20 73 75 70 70 6f 72 74 |ases are| support|
|00001cf0| 65 64 20 6f 6e 20 4f 53 | 20 58 20 64 75 65 20 74 |ed on OS| X due t|
|00001d00| 6f 20 64 72 69 76 65 72 | 20 69 73 73 75 65 73 2e |o driver| issues.|
|00001d10| 22 20 77 69 74 68 20 22 | 4f 4b 22 0a 20 20 65 6e |" with "|OK".  en|
|00001d20| 64 20 69 66 0a 65 6e 64 | 20 6f 70 65 6e 53 74 61 |d if.end| openSta|
|00001d30| 63 6b 0a 00 00 60 00 02 | 80 80 80 80 80 80 00 00 |ck...`..|........|
|00001d40| ac ac ac ac ac ac 00 00 | 80 00 01 0e 00 af 01 92 |........|........|
|00001d50| 00 ce 00 00 00 02 0a 63 | 6f 6c 6f 72 6c 69 73 74 |.......c|olorlist|
|00001d60| 00 00 5b 32 35 35 2c 31 | 32 38 2c 31 32 38 0a 32 |..[255,1|28,128.2|
|00001d70| 35 35 2c 32 35 35 2c 31 | 32 38 0a 31 32 38 2c 32 |55,255,1|28.128,2|
|00001d80| 35 35 2c 31 32 38 0a 30 | 2c 32 35 35 2c 31 32 38 |55,128.0|,255,128|
|00001d90| 0a 31 32 38 2c 32 35 35 | 2c 32 35 35 0a 30 2c 31 |.128,255|,255.0,1|
|00001da0| 32 38 2c 32 35 35 0a 32 | 35 35 2c 31 32 38 2c 31 |28,255.2|55,128,1|
|00001db0| 39 32 0a 32 35 35 2c 31 | 32 38 2c 32 35 35 09 72 |92.255,1|28,255.r|
|00001dc0| 65 76 73 74 61 63 6b 00 | 00 05 66 61 6c 73 65 00 |evstack.|..false.|
|00001dd0| 00 00 00 00 00 00 00 00 | 11 44 61 74 61 62 61 73 |........|.Databas|
|00001de0| 65 20 4d 61 6e 61 67 65 | 72 00 00 00 00 22 00 0e |e Manage|r...."..|
|00001df0| 00 55 00 0a 68 65 6c 76 | 65 74 69 63 61 00 00 18 |.U..helv|etica...|
|00001e00| 00 55 00 0a 68 65 6c 76 | 65 74 69 63 61 00 00 18 |.U..helv|etica...|
|00001e10| 00 55 00 06 41 72 69 61 | 6c 00 00 18 00 57 00 06 |.U..Aria|l....W..|
|00001e20| 41 72 69 61 6c 00 00 0c | 00 55 00 06 41 72 69 61 |Arial...|.U..Aria|
|00001e30| 6c 00 00 0c 00 55 00 07 | 47 65 6e 65 76 61 00 00 |l....U..|Geneva..|
|00001e40| 0c 00 55 00 0a 68 65 6c | 76 65 74 69 63 61 00 00 |..U..hel|vetica..|
|00001e50| 0c 00 55 00 08 43 6f 75 | 72 69 65 72 00 00 0e 00 |..U..Cou|rier....|
|00001e60| 57 00 0a 68 65 6c 76 65 | 74 69 63 61 00 00 0a 00 |W..helve|tica....|
|00001e70| 55 00 0c 43 6f 75 72 69 | 65 72 20 4e 65 77 00 00 |U..Couri|er New..|
|00001e80| 0b 00 55 00 0c 43 6f 75 | 72 69 65 72 20 4e 65 77 |..U..Cou|rier New|
|00001e90| 00 00 0c 00 55 00 0c 43 | 6f 75 72 69 65 72 20 4e |....U..C|ourier N|
|00001ea0| 65 77 00 00 0c 00 57 00 | 0a 68 65 6c 76 65 74 69 |ew....W.|.helveti|
|00001eb0| 63 61 00 00 0c 00 57 00 | 0c 63 6f 75 72 69 65 72 |ca....W.|.courier|
|00001ec0| 20 6e 65 77 00 00 0a 00 | 55 00 06 41 72 69 61 6c | new....|U..Arial|
|00001ed0| 00 00 00 00 55 00 06 41 | 72 69 61 6c 00 00 0a 00 |....U..A|rial....|
|00001ee0| 55 00 0a 68 65 6c 76 65 | 74 69 63 61 00 00 0c 00 |U..helve|tica....|
|00001ef0| 55 00 09 63 68 61 72 63 | 6f 61 6c 00 00 0a 40 55 |U..charc|oal...@U|
|00001f00| 00 07 47 65 6e 65 76 61 | 00 00 0a 00 55 00 07 47 |..Geneva|....U..G|
|00001f10| 65 6e 65 76 61 00 00 18 | 00 55 00 07 47 65 6e 65 |eneva...|.U..Gene|
|00001f20| 76 61 00 00 0e 00 55 00 | 07 47 65 6e 65 76 61 00 |va....U.|.Geneva.|
|00001f30| 00 0a 00 55 00 0e 6d 73 | 20 73 61 6e 73 20 73 65 |...U..ms| sans se|
|00001f40| 72 69 66 00 00 0b 10 55 | 00 0e 4c 75 63 69 64 61 |rif....U|..Lucida|
|00001f50| 20 47 72 61 6e 64 65 00 | 00 0b 40 55 00 0e 4c 75 | Grande.|..@U..Lu|
|00001f60| 63 69 64 61 20 47 72 61 | 6e 64 65 00 00 0b 00 55 |cida Gra|nde....U|
|00001f70| 00 0e 4c 75 63 69 64 61 | 20 47 72 61 6e 64 65 00 |..Lucida| Grande.|
|00001f80| 00 0a 00 57 00 07 47 65 | 6e 65 76 61 00 00 0b 50 |...W..Ge|neva...P|
|00001f90| 55 00 0e 4c 75 63 69 64 | 61 20 47 72 61 6e 64 65 |U..Lucid|a Grande|
|00001fa0| 00 00 0b 50 57 00 0e 4c | 75 63 69 64 61 20 47 72 |...PW..L|ucida Gr|
|00001fb0| 61 6e 64 65 00 00 0b 00 | 57 00 0e 4c 75 63 69 64 |ande....|W..Lucid|
|00001fc0| 61 20 47 72 61 6e 64 65 | 00 00 0a 40 57 00 07 47 |a Grande|...@W..G|
|00001fd0| 65 6e 65 76 61 00 00 0a | 10 55 00 07 47 65 6e 65 |eneva...|.U..Gene|
|00001fe0| 76 61 00 00 0a 10 57 00 | 07 47 65 6e 65 76 61 00 |va....W.|.Geneva.|
|00001ff0| 00 0a 00 55 00 0e 4c 75 | 63 69 64 61 20 47 72 61 |...U..Lu|cida Gra|
|00002000| 6e 64 65 00 00 00 00 00 | ff ff 00 05 42 6c 75 65 |nde.....|....Blue|
|00002010| 00 ff ff 00 00 00 00 00 | 00 00 00 00 00 ff ff 00 |........|........|
|00002020| 05 42 6c 75 65 00 01 18 | 00 0c 63 52 45 56 47 65 |.Blue...|..cREVGe|
|00002030| 6e 65 72 61 6c 00 00 00 | 00 07 0f 73 63 72 69 70 |neral...|...scrip|
|00002040| 74 43 68 65 63 6b 73 75 | 6d 00 00 10 83 8c f5 48 |tChecksu|m......H|
|00002050| 46 35 27 dd d7 5d 6b 58 | 5e 10 47 1e 0a 62 6f 6f |F5'..]kX|^.G..boo|
|00002060| 6b 6d 61 72 6b 73 00 00 | 00 0c 68 61 6e 64 6c 65 |kmarks..|..handle|
|00002070| 72 4c 69 73 74 00 00 b5 | 72 65 73 69 7a 65 53 74 |rList...|resizeSt|
|00002080| 61 63 6b 0a 43 6f 6e 6e | 65 63 74 54 6f 44 61 74 |ack.Conn|ectToDat|
|00002090| 61 62 61 73 65 0a 67 65 | 74 53 51 4c 50 61 72 61 |abase.ge|tSQLPara|
|000020a0| 6d 73 0a 64 6f 71 75 65 | 72 79 0a 63 6c 6f 73 65 |ms.doque|ry.close|
|000020b0| 64 61 74 61 63 6f 6e 6e | 65 63 74 69 6f 6e 0a 63 |dataconn|ection.c|
|000020c0| 6c 6f 73 65 63 75 72 73 | 6f 72 63 6f 6e 6e 65 63 |losecurs|orconnec|
|000020d0| 74 69 6f 6e 0a 70 72 65 | 4f 70 65 6e 53 74 61 63 |tion.pre|OpenStac|
|000020e0| 6b 0a 6f 70 65 6e 53 74 | 61 63 6b 0a 70 72 65 4f |k.openSt|ack.preO|
|000020f0| 70 65 6e 43 61 72 64 0a | 63 6c 6f 73 65 63 6f 6e |penCard.|closecon|
|00002100| 6e 65 63 74 69 6f 6e 73 | 0a 64 69 73 70 6c 61 79 |nections|.display|
|00002110| 72 65 73 75 6c 74 73 65 | 74 0a 72 61 6e 64 63 6f |resultse|t.randco|
|00002120| 6c 6f 72 0a 6f 70 65 6e | 53 74 61 63 6b 0b 74 65 |lor.open|Stack.te|
|00002130| 6d 70 53 63 72 69 70 74 | 00 00 00 0c 70 72 65 76 |mpScript|....prev|
|00002140| 48 61 6e 64 6c 65 72 00 | 00 0c 70 72 65 4f 70 65 |Handler.|..preOpe|
|00002150| 6e 53 74 61 63 6b 10 73 | 63 72 69 70 74 53 65 6c |nStack.s|criptSel|
|00002160| 65 63 74 69 6f 6e 00 00 | 11 63 68 61 72 20 34 35 |ection..|.char 45|
|00002170| 32 34 20 74 6f 20 34 35 | 32 33 07 73 63 72 69 70 |24 to 45|23.scrip|
|00002180| 74 00 22 24 3c 70 3e 6f | 6e 20 72 65 73 69 7a 65 |t."$<p>o|n resize|
|00002190| 53 74 61 63 6b 3c 2f 70 | 3e 0a 3c 70 3e 20 20 72 |Stack</p|>.<p>  r|
|000021a0| 65 76 55 70 64 61 74 65 | 47 65 6f 6d 65 74 72 79 |evUpdate|Geometry|
|000021b0| 3c 2f 70 3e 0a 3c 70 3e | 65 6e 64 20 72 65 73 69 |</p>.<p>|end resi|
|000021c0| 7a 65 53 74 61 63 6b 3c | 2f 70 3e 0a 3c 70 3e 3c |zeStack<|/p>.<p><|
|000021d0| 2f 70 3e 0a 3c 70 3e 6f | 6e 20 43 6f 6e 6e 65 63 |/p>.<p>o|n Connec|
|000021e0| 74 54 6f 44 61 74 61 62 | 61 73 65 3c 2f 70 3e 0a |tToDatab|ase</p>.|
|000021f0| 3c 70 3e 20 20 69 66 20 | 74 68 65 20 6c 61 62 65 |<p>  if |the labe|
|00002200| 6c 20 6f 66 20 62 74 6e | 20 22 64 62 74 79 70 65 |l of btn| "dbtype|
|00002210| 22 20 69 73 20 22 6d 79 | 73 71 6c 22 20 74 68 65 |" is "my|sql" the|
|00002220| 6e 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 69 66 20 |n</p>.<p|>    if |
|00002230| 74 68 65 20 70 6c 61 74 | 66 6f 72 6d 20 69 73 20 |the plat|form is |
|00002240| 6d 61 63 6f 73 20 74 68 | 65 6e 3c 2f 70 3e 0a 3c |macos th|en</p>.<|
|00002250| 70 3e 20 20 20 20 20 20 | 69 66 20 74 68 65 20 73 |p>      |if the s|
|00002260| 79 73 74 65 6d 56 65 72 | 73 69 6f 6e 20 26 6c 74 |ystemVer|sion &lt|
|00002270| 3b 20 31 30 20 74 68 65 | 6e 3c 2f 70 3e 0a 3c 70 |; 10 the|n</p>.<p|
|00002280| 3e 20 20 20 20 20 20 20 | 20 70 75 74 20 74 68 65 |>       | put the|
|00002290| 20 64 69 72 65 63 74 6f | 72 79 20 69 6e 74 6f 20 | directo|ry into |
|000022a0| 74 44 69 72 65 63 74 6f | 72 79 3c 2f 70 3e 0a 3c |tDirecto|ry</p>.<|
|000022b0| 70 3e 20 20 20 20 20 20 | 20 20 73 65 74 20 74 68 |p>      |  set th|
|000022c0| 65 20 64 69 72 65 63 74 | 6f 72 79 20 74 6f 20 73 |e direct|ory to s|
|000022d0| 70 65 63 69 61 6c 46 6f | 6c 64 65 72 50 61 74 68 |pecialFo|lderPath|
|000022e0| 28 45 78 74 65 6e 73 69 | 6f 6e 29 3c 2f 70 3e 0a |(Extensi|on)</p>.|
|000022f0| 3c 70 3e 20 20 20 20 20 | 20 20 20 73 65 74 20 74 |<p>     |   set t|
|00002300| 68 65 20 77 68 6f 6c 65 | 4d 61 74 63 68 65 73 20 |he whole|Matches |
|00002310| 74 6f 20 74 72 75 65 3c | 2f 70 3e 0a 3c 70 3e 20 |to true<|/p>.<p> |
|00002320| 20 20 20 20 20 20 20 69 | 66 20 22 4d 79 53 51 4c |       i|f "MySQL|
|00002330| 20 4c 69 62 72 61 72 79 | 22 20 69 73 20 6e 6f 74 | Library|" is not|
|00002340| 20 69 6e 20 74 68 65 20 | 66 69 6c 65 73 20 74 68 | in the |files th|
|00002350| 65 6e 3c 2f 70 3e 0a 3c | 70 3e 20 20 20 20 20 20 |en</p>.<|p>      |
|00002360| 20 20 20 20 61 6e 73 77 | 65 72 20 22 59 6f 75 20 |    answ|er "You |
|00002370| 6d 75 73 74 20 68 61 76 | 65 20 74 68 65 20 4d 79 |must hav|e the My|
|00002380| 53 51 4c 20 4c 69 62 72 | 61 72 79 20 69 6e 73 74 |SQL Libr|ary inst|
|00002390| 61 6c 6c 65 64 20 69 6e | 20 79 6f 75 72 20 45 78 |alled in| your Ex|
|000023a0| 74 65 6e 73 69 6f 6e 73 | 20 66 6f 6c 64 65 72 20 |tensions| folder |
|000023b0| 69 6e 20 79 6f 75 72 20 | 53 79 73 74 65 6d 20 66 |in your |System f|
|000023c0| 6f 6c 64 65 72 20 74 6f | 20 63 6f 6e 6e 65 63 74 |older to| connect|
|000023d0| 20 74 6f 20 61 20 4d 79 | 53 51 4c 20 64 61 74 61 | to a My|SQL data|
|000023e0| 62 61 73 65 2e 22 20 77 | 69 74 68 20 43 61 6e 63 |base." w|ith Canc|
|000023f0| 65 6c 3c 2f 70 3e 0a 3c | 70 3e 20 20 20 20 20 20 |el</p>.<|p>      |
|00002400| 20 20 20 20 73 65 74 20 | 74 68 65 20 64 69 72 65 |    set |the dire|
|00002410| 63 74 6f 72 79 20 74 6f | 20 74 44 69 72 65 63 74 |ctory to| tDirect|
|00002420| 6f 72 79 3c 2f 70 3e 0a | 3c 70 3e 20 20 20 20 20 |ory</p>.|<p>     |
|00002430| 20 20 20 20 20 65 78 69 | 74 20 63 6f 6e 6e 65 63 |     exi|t connec|
|00002440| 74 54 6f 44 61 74 61 62 | 61 73 65 3c 2f 70 3e 0a |tToDatab|ase</p>.|
|00002450| 3c 70 3e 20 20 20 20 20 | 20 20 20 65 6e 64 20 69 |<p>     |   end i|
|00002460| 66 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 20 20 20 |f</p>.<p|>       |
|00002470| 20 73 65 74 20 74 68 65 | 20 64 69 72 65 63 74 6f | set the| directo|
|00002480| 72 79 20 74 6f 20 74 44 | 69 72 65 63 74 6f 72 79 |ry to tD|irectory|
|00002490| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 20 20 20 20 |</p>.<p>|        |
|000024a0| 73 65 74 20 74 68 65 20 | 77 68 6f 6c 65 4d 61 74 |set the |wholeMat|
|000024b0| 63 68 65 73 20 74 6f 20 | 66 61 6c 73 65 3c 2f 70 |ches to |false</p|
|000024c0| 3e 0a 3c 70 3e 20 20 20 | 20 20 20 65 6e 64 20 69 |>.<p>   |   end i|
|000024d0| 66 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 65 6e 64 |f</p>.<p|>    end|
|000024e0| 20 69 66 3c 2f 70 3e 0a | 3c 70 3e 20 20 65 6e 64 | if</p>.|<p>  end|
|000024f0| 20 69 66 3c 2f 70 3e 0a | 3c 70 3e 3c 2f 70 3e 0a | if</p>.|<p></p>.|
|00002500| 3c 70 3e 20 20 6c 6f 63 | 61 6c 20 63 69 6e 66 6f |<p>  loc|al cinfo|
|00002510| 2c 6e 65 77 63 6f 6e 6e | 69 64 2c 64 62 72 65 73 |,newconn|id,dbres|
|00002520| 75 6c 74 3c 2f 70 3e 0a | 3c 70 3e 3c 2f 70 3e 0a |ult</p>.|<p></p>.|
|00002530| 3c 70 3e 3c 2f 70 3e 0a | 3c 70 3e 20 20 70 75 74 |<p></p>.|<p>  put|
|00002540| 20 22 64 62 74 79 70 65 | 22 2c 6c 61 62 65 6c 20 | "dbtype|",label |
|00002550| 6f 66 20 62 75 74 74 6f | 6e 20 22 44 42 54 59 50 |of butto|n "DBTYP|
|00002560| 45 22 26 61 6d 70 3b 63 | 72 26 61 6d 70 3b 5c 3c |E"&amp;c|r&amp;\<|
|00002570| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 20 20 22 64 62 |/p>.<p> |     "db|
|00002580| 68 6f 73 74 22 2c 66 69 | 65 6c 64 20 22 44 42 48 |host",fi|eld "DBH|
|00002590| 4f 53 54 22 26 61 6d 70 | 3b 63 72 26 61 6d 70 3b |OST"&amp|;cr&amp;|
|000025a0| 5c 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 20 20 22 |\</p>.<p|>      "|
|000025b0| 64 62 64 61 74 61 62 61 | 73 65 22 2c 66 69 65 6c |dbdataba|se",fiel|
|000025c0| 64 20 22 44 42 44 41 54 | 41 42 41 53 45 22 26 61 |d "DBDAT|ABASE"&a|
|000025d0| 6d 70 3b 63 72 26 61 6d | 70 3b 5c 3c 2f 70 3e 0a |mp;cr&am|p;\</p>.|
|000025e0| 3c 70 3e 20 20 20 20 20 | 20 22 64 62 75 73 65 72 |<p>     | "dbuser|
|000025f0| 22 2c 66 69 65 6c 64 20 | 22 44 42 55 53 45 52 22 |",field |"DBUSER"|
|00002600| 26 61 6d 70 3b 63 72 26 | 61 6d 70 3b 5c 3c 2f 70 |&amp;cr&|amp;\</p|
|00002610| 3e 0a 3c 70 3e 20 20 20 | 20 20 20 22 64 62 70 61 |>.<p>   |   "dbpa|
|00002620| 73 73 77 6f 72 64 22 2c | 66 69 65 6c 64 20 22 44 |ssword",|field "D|
|00002630| 42 50 41 53 53 57 4f 52 | 44 22 20 69 6e 74 6f 20 |BPASSWOR|D" into |
|00002640| 63 49 6e 66 6f 3c 2f 70 | 3e 0a 3c 70 3e 3c 2f 70 |cInfo</p|>.<p></p|
|00002650| 3e 0a 3c 70 3e 3c 2f 70 | 3e 0a 3c 70 3e 20 20 73 |>.<p></p|>.<p>  s|
|00002660| 70 6c 69 74 20 63 69 6e | 66 6f 20 62 79 20 72 65 |plit cin|fo by re|
|00002670| 74 75 72 6e 20 61 6e 64 | 20 63 6f 6d 6d 61 3c 2f |turn and| comma</|
|00002680| 70 3e 0a 3c 70 3e 20 20 | 70 75 74 20 72 65 76 64 |p>.<p>  |put revd|
|00002690| 62 5f 63 6f 6e 6e 65 63 | 74 28 63 69 6e 66 6f 5b |b_connec|t(cinfo[|
|000026a0| 22 64 62 74 79 70 65 22 | 5d 2c 63 69 6e 66 6f 5b |"dbtype"|],cinfo[|
|000026b0| 22 64 62 68 6f 73 74 22 | 5d 2c 63 69 6e 66 6f 5b |"dbhost"|],cinfo[|
|000026c0| 22 64 62 64 61 74 61 62 | 61 73 65 22 5d 2c 5c 3c |"dbdatab|ase"],\<|
|000026d0| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 20 20 63 69 6e |/p>.<p> |     cin|
|000026e0| 66 6f 5b 22 64 62 75 73 | 65 72 22 5d 2c 63 69 6e |fo["dbus|er"],cin|
|000026f0| 66 6f 5b 22 64 62 70 61 | 73 73 77 6f 72 64 22 5d |fo["dbpa|ssword"]|
|00002700| 2c 33 2a 31 30 32 34 2c | 63 69 6e 66 6f 5b 22 64 |,3*1024,|cinfo["d|
|00002710| 62 75 73 65 72 22 5d 2c | 63 69 6e 66 6f 5b 22 64 |buser"],|cinfo["d|
|00002720| 62 70 61 73 73 77 6f 72 | 64 22 5d 29 20 69 6e 74 |bpasswor|d"]) int|
|00002730| 6f 20 64 62 72 65 73 75 | 6c 74 3c 2f 70 3e 0a 3c |o dbresu|lt</p>.<|
|00002740| 70 3e 20 20 69 66 20 64 | 62 72 65 73 75 6c 74 20 |p>  if d|bresult |
|00002750| 69 73 20 61 20 6e 75 6d | 62 65 72 20 74 68 65 6e |is a num|ber then|
|00002760| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 70 75 74 20 |</p>.<p>|    put |
|00002770| 64 62 72 65 73 75 6c 74 | 20 69 6e 74 6f 20 6e 65 |dbresult| into ne|
|00002780| 77 63 6f 6e 6e 69 64 3c | 2f 70 3e 0a 3c 70 3e 20 |wconnid<|/p>.<p> |
|00002790| 20 20 20 63 6c 6f 6e 65 | 20 73 74 61 63 6b 20 22 |   clone| stack "|
|000027a0| 64 61 74 61 63 6f 6e 6e | 65 63 74 69 6f 6e 22 3c |dataconn|ection"<|
|000027b0| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 70 75 74 20 20 |/p>.<p> |   put  |
|000027c0| 22 64 61 74 61 63 6f 6e | 6e 65 63 74 69 6f 6e 2d |"datacon|nection-|
|000027d0| 22 26 61 6d 70 3b 6e 65 | 77 63 6f 6e 6e 69 64 20 |"&amp;ne|wconnid |
|000027e0| 69 6e 74 6f 20 6e 73 74 | 61 63 6b 6e 61 6d 65 3c |into nst|ackname<|
|000027f0| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 73 65 74 20 74 |/p>.<p> |   set t|
|00002800| 68 65 20 6e 61 6d 65 20 | 6f 66 20 74 68 65 20 74 |he name |of the t|
|00002810| 6f 70 73 74 61 63 6b 20 | 74 6f 20 6e 73 74 61 63 |opstack |to nstac|
|00002820| 6b 6e 61 6d 65 3c 2f 70 | 3e 0a 3c 70 3e 20 20 20 |kname</p|>.<p>   |
|00002830| 20 73 65 74 20 74 68 65 | 20 6d 61 69 6e 73 74 61 | set the| mainsta|
|00002840| 63 6b 20 6f 66 20 73 74 | 61 63 6b 20 6e 73 74 61 |ck of st|ack nsta|
|00002850| 63 6b 6e 61 6d 65 20 74 | 6f 20 22 72 65 76 44 61 |ckname t|o "revDa|
|00002860| 74 61 62 61 73 65 22 3c | 2f 70 3e 0a 3c 70 3e 20 |tabase"<|/p>.<p> |
|00002870| 20 20 20 73 65 74 20 74 | 68 65 20 74 69 74 6c 65 |   set t|he title|
|00002880| 20 6f 66 20 73 74 61 63 | 6b 20 6e 73 74 61 63 6b | of stac|k nstack|
|00002890| 6e 61 6d 65 20 74 6f 20 | 6e 73 74 61 63 6b 6e 61 |name to |nstackna|
|000028a0| 6d 65 3c 2f 70 3e 0a 3c | 70 3e 20 20 20 20 73 65 |me</p>.<|p>    se|
|000028b0| 74 20 74 68 65 20 64 62 | 63 6f 6e 6e 65 63 74 69 |t the db|connecti|
|000028c0| 6f 6e 69 64 20 6f 66 20 | 73 74 61 63 6b 20 6e 73 |onid of |stack ns|
|000028d0| 74 61 63 6b 6e 61 6d 65 | 20 74 6f 20 6e 65 77 63 |tackname| to newc|
|000028e0| 6f 6e 6e 69 64 3c 2f 70 | 3e 0a 3c 70 3e 20 20 20 |onnid</p|>.<p>   |
|000028f0| 20 73 65 74 20 74 68 65 | 20 62 61 63 6b 67 72 6f | set the| backgro|
|00002900| 75 6e 64 63 6f 6c 6f 72 | 20 6f 66 20 73 74 61 63 |undcolor| of stac|
|00002910| 6b 20 6e 73 74 61 63 6b | 6e 61 6d 65 20 74 6f 20 |k nstack|name to |
|00002920| 72 61 6e 64 63 6f 6c 6f | 72 28 29 3c 2f 70 3e 0a |randcolo|r()</p>.|
|00002930| 3c 70 3e 20 20 20 20 73 | 65 74 20 74 68 65 20 63 |<p>    s|et the c|
|00002940| 61 6e 74 4d 6f 64 69 66 | 79 20 6f 66 20 73 74 61 |antModif|y of sta|
|00002950| 63 6b 20 6e 73 74 61 63 | 6b 6e 61 6d 65 20 74 6f |ck nstac|kname to|
|00002960| 20 74 72 75 65 3c 2f 70 | 3e 0a 3c 70 3e 20 20 65 | true</p|>.<p>  e|
|00002970| 6c 73 65 20 61 6e 73 77 | 65 72 20 64 62 72 65 73 |lse answ|er dbres|
|00002980| 75 6c 74 3c 2f 70 3e 0a | 3c 70 3e 65 6e 64 20 43 |ult</p>.|<p>end C|
|00002990| 6f 6e 6e 65 63 74 54 6f | 44 61 74 61 62 61 73 65 |onnectTo|Database|
|000029a0| 3c 2f 70 3e 0a 3c 70 3e | 3c 2f 70 3e 0a 3c 70 3e |</p>.<p>|</p>.<p>|
|000029b0| 6f 6e 20 67 65 74 53 51 | 4c 50 61 72 61 6d 73 20 |on getSQ|LParams |
|000029c0| 74 68 65 71 75 65 72 79 | 2c 40 74 70 61 72 61 6d |thequery|,@tparam|
|000029d0| 73 3c 2f 70 3e 0a 3c 70 | 3e 20 20 6c 6f 63 61 6c |s</p>.<p|>  local|
|000029e0| 20 74 68 65 6f 66 66 73 | 65 74 2c 62 69 6e 64 6e | theoffs|et,bindn|
|000029f0| 75 6d 62 65 72 2c 62 69 | 6e 64 76 61 6c 75 65 2c |umber,bi|ndvalue,|
|00002a00| 74 66 69 6c 65 6e 61 6d | 65 3c 2f 70 3e 0a 3c 70 |tfilenam|e</p>.<p|
|00002a10| 3e 20 20 70 75 74 20 30 | 20 69 6e 74 6f 20 74 68 |>  put 0| into th|
|00002a20| 65 6f 66 66 73 65 74 3c | 2f 70 3e 0a 3c 70 3e 20 |eoffset<|/p>.<p> |
|00002a30| 20 70 75 74 20 6f 66 66 | 73 65 74 28 22 3a 22 2c | put off|set(":",|
|00002a40| 74 68 65 71 75 65 72 79 | 29 20 69 6e 74 6f 20 74 |thequery|) into t|
|00002a50| 68 65 6f 66 66 73 65 74 | 3c 2f 70 3e 0a 3c 70 3e |heoffset|</p>.<p>|
|00002a60| 20 20 72 65 70 65 61 74 | 20 77 68 69 6c 65 20 74 |  repeat| while t|
|00002a70| 68 65 6f 66 66 73 65 74 | 20 69 73 20 6e 6f 74 20 |heoffset| is not |
|00002a80| 30 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 70 75 74 |0</p>.<p|>    put|
|00002a90| 20 63 68 61 72 20 74 68 | 65 6f 66 66 73 65 74 2b | char th|eoffset+|
|00002aa0| 31 20 6f 66 20 74 68 65 | 71 75 65 72 79 20 69 6e |1 of the|query in|
|00002ab0| 74 6f 20 62 69 6e 64 6e | 75 6d 62 65 72 3c 2f 70 |to bindn|umber</p|
|00002ac0| 3e 0a 3c 70 3e 20 20 20 | 20 61 64 64 20 31 20 74 |>.<p>   | add 1 t|
|00002ad0| 6f 20 74 68 65 6f 66 66 | 73 65 74 3c 2f 70 3e 0a |o theoff|set</p>.|
|00002ae0| 3c 70 3e 20 20 20 20 69 | 66 20 62 69 6e 64 6e 75 |<p>    i|f bindnu|
|00002af0| 6d 62 65 72 20 69 73 20 | 61 20 6e 75 6d 62 65 72 |mber is |a number|
|00002b00| 20 74 68 65 6e 3c 2f 70 | 3e 0a 3c 70 3e 20 20 20 | then</p|>.<p>   |
|00002b10| 20 20 20 69 66 20 74 70 | 61 72 61 6d 73 5b 62 69 |   if tp|arams[bi|
|00002b20| 6e 64 6e 75 6d 62 65 72 | 5d 20 69 73 20 65 6d 70 |ndnumber|] is emp|
|00002b30| 74 79 20 74 68 65 6e 3c | 2f 70 3e 0a 3c 70 3e 20 |ty then<|/p>.<p> |
|00002b40| 20 20 20 20 20 20 20 73 | 65 74 20 74 68 65 20 64 |       s|et the d|
|00002b50| 69 61 6c 6f 67 64 61 74 | 61 20 74 6f 20 22 57 68 |ialogdat|a to "Wh|
|00002b60| 61 74 20 69 73 20 74 68 | 65 20 76 61 6c 75 65 20 |at is th|e value |
|00002b70| 6f 66 20 22 26 61 6d 70 | 3b 26 61 6d 70 3b 22 3a |of "&amp|;&amp;":|
|00002b80| 22 26 61 6d 70 3b 62 69 | 6e 64 6e 75 6d 62 65 72 |"&amp;bi|ndnumber|
|00002b90| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 20 20 20 20 |</p>.<p>|        |
|00002ba0| 6d 6f 64 61 6c 20 22 62 | 69 6e 64 64 69 61 6c 6f |modal "b|inddialo|
|00002bb0| 67 22 3c 2f 70 3e 0a 3c | 70 3e 20 20 20 20 20 20 |g"</p>.<|p>      |
|00002bc0| 20 20 70 75 74 20 74 68 | 65 20 64 69 61 6c 6f 67 |  put th|e dialog|
|00002bd0| 64 61 74 61 20 69 6e 74 | 6f 20 62 69 6e 64 76 61 |data int|o bindva|
|00002be0| 6c 75 65 3c 2f 70 3e 0a | 3c 70 3e 20 20 20 20 20 |lue</p>.|<p>     |
|00002bf0| 20 20 20 69 66 20 62 69 | 6e 64 76 61 6c 75 65 20 |   if bi|ndvalue |
|00002c00| 69 73 20 65 6d 70 74 79 | 20 74 68 65 6e 20 65 78 |is empty| then ex|
|00002c10| 69 74 20 72 65 70 65 61 | 74 3c 2f 70 3e 0a 3c 70 |it repea|t</p>.<p|
|00002c20| 3e 20 20 20 20 20 20 20 | 20 69 66 20 69 74 65 6d |>       | if item|
|00002c30| 20 31 20 6f 66 20 62 69 | 6e 64 76 61 6c 75 65 20 | 1 of bi|ndvalue |
|00002c40| 69 73 20 22 75 73 65 66 | 69 6c 65 22 20 74 68 65 |is "usef|ile" the|
|00002c50| 6e 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 20 20 20 |n</p>.<p|>       |
|00002c60| 20 20 20 70 75 74 20 69 | 74 65 6d 20 32 20 6f 66 |   put i|tem 2 of|
|00002c70| 20 62 69 6e 64 76 61 6c | 75 65 20 69 6e 74 6f 20 | bindval|ue into |
|00002c80| 74 66 69 6c 65 6e 61 6d | 65 3c 2f 70 3e 0a 3c 70 |tfilenam|e</p>.<p|
|00002c90| 3e 20 20 20 20 20 20 20 | 20 20 20 70 75 74 20 22 |>       |   put "|
|00002ca0| 2a 62 22 26 61 6d 70 3b | 75 72 6c 20 28 22 62 69 |*b"&amp;|url ("bi|
|00002cb0| 6e 66 69 6c 65 3a 22 26 | 61 6d 70 3b 74 66 69 6c |nfile:"&|amp;tfil|
|00002cc0| 65 6e 61 6d 65 29 20 69 | 6e 74 6f 20 74 70 61 72 |ename) i|nto tpar|
|00002cd0| 61 6d 73 5b 62 69 6e 64 | 6e 75 6d 62 65 72 5d 3c |ams[bind|number]<|
|00002ce0| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 20 20 20 20 65 |/p>.<p> |       e|
|00002cf0| 6c 73 65 20 70 75 74 20 | 62 69 6e 64 76 61 6c 75 |lse put |bindvalu|
|00002d00| 65 20 69 6e 74 6f 20 74 | 70 61 72 61 6d 73 5b 62 |e into t|params[b|
|00002d10| 69 6e 64 6e 75 6d 62 65 | 72 5d 3c 2f 70 3e 0a 3c |indnumbe|r]</p>.<|
|00002d20| 70 3e 20 20 20 20 20 20 | 65 6e 64 20 69 66 3c 2f |p>      |end if</|
|00002d30| 70 3e 0a 3c 70 3e 20 20 | 20 20 65 6c 73 65 20 65 |p>.<p>  |  else e|
|00002d40| 78 69 74 20 72 65 70 65 | 61 74 3c 2f 70 3e 0a 3c |xit repe|at</p>.<|
|00002d50| 70 3e 20 20 20 20 67 65 | 74 20 6f 66 66 73 65 74 |p>    ge|t offset|
|00002d60| 28 22 3a 22 2c 74 68 65 | 71 75 65 72 79 2c 74 68 |(":",the|query,th|
|00002d70| 65 6f 66 66 73 65 74 29 | 3c 2f 70 3e 0a 3c 70 3e |eoffset)|</p>.<p>|
|00002d80| 20 20 20 20 69 66 20 69 | 74 20 69 73 20 30 20 74 |    if i|t is 0 t|
|00002d90| 68 65 6e 20 65 78 69 74 | 20 72 65 70 65 61 74 3c |hen exit| repeat<|
|00002da0| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 65 6c 73 65 20 |/p>.<p> |   else |
|00002db0| 70 75 74 20 69 74 2b 74 | 68 65 6f 66 66 73 65 74 |put it+t|heoffset|
|00002dc0| 20 69 6e 74 6f 20 74 68 | 65 6f 66 66 73 65 74 3c | into th|eoffset<|
|00002dd0| 2f 70 3e 0a 3c 70 3e 20 | 20 65 6e 64 20 72 65 70 |/p>.<p> | end rep|
|00002de0| 65 61 74 3c 2f 70 3e 0a | 3c 70 3e 65 6e 64 20 67 |eat</p>.|<p>end g|
|00002df0| 65 74 53 51 4c 50 61 72 | 61 6d 73 3c 2f 70 3e 0a |etSQLPar|ams</p>.|
|00002e00| 3c 70 3e 3c 2f 70 3e 0a | 3c 70 3e 66 75 6e 63 74 |<p></p>.|<p>funct|
|00002e10| 69 6f 6e 20 64 6f 71 75 | 65 72 79 20 74 68 65 63 |ion doqu|ery thec|
|00002e20| 6f 6e 6e 65 63 74 69 6f | 6e 2c 74 68 65 71 75 65 |onnectio|n,theque|
|00002e30| 72 79 3c 2f 70 3e 0a 3c | 70 3e 20 20 6c 6f 63 61 |ry</p>.<|p>  loca|
|00002e40| 6c 20 74 70 61 72 61 6d | 73 2c 63 75 72 73 6f 72 |l tparam|s,cursor|
|00002e50| 69 64 2c 64 62 72 65 73 | 75 6c 74 2c 6e 75 6d 63 |id,dbres|ult,numc|
|00002e60| 6f 6c 75 6d 6e 73 2c 6e | 75 6d 72 6f 77 73 2c 72 |olumns,n|umrows,r|
|00002e70| 6f 77 73 61 66 66 65 63 | 74 65 64 3c 2f 70 3e 0a |owsaffec|ted</p>.|
|00002e80| 3c 70 3e 20 20 67 65 74 | 53 51 4c 50 61 72 61 6d |<p>  get|SQLParam|
|00002e90| 73 20 74 68 65 71 75 65 | 72 79 2c 74 70 61 72 61 |s theque|ry,tpara|
|00002ea0| 6d 73 3c 2f 70 3e 0a 3c | 70 3e 20 20 69 66 20 77 |ms</p>.<|p>  if w|
|00002eb0| 6f 72 64 20 31 20 6f 66 | 20 74 68 65 71 75 65 72 |ord 1 of| thequer|
|00002ec0| 79 20 69 73 20 61 6d 6f | 6e 67 20 74 68 65 20 69 |y is amo|ng the i|
|00002ed0| 74 65 6d 73 20 6f 66 20 | 22 73 65 6c 65 63 74 2c |tems of |"select,|
|00002ee0| 73 68 6f 77 2c 64 65 73 | 63 72 69 62 65 22 20 74 |show,des|cribe" t|
|00002ef0| 68 65 6e 3c 2f 70 3e 0a | 3c 70 3e 20 20 20 20 70 |hen</p>.|<p>    p|
|00002f00| 75 74 20 72 65 76 64 62 | 5f 71 75 65 72 79 28 74 |ut revdb|_query(t|
|00002f10| 68 65 63 6f 6e 6e 65 63 | 74 69 6f 6e 2c 74 68 65 |heconnec|tion,the|
|00002f20| 71 75 65 72 79 2c 22 74 | 70 61 72 61 6d 73 22 29 |query,"t|params")|
|00002f30| 20 69 6e 74 6f 20 64 62 | 72 65 73 75 6c 74 3c 2f | into db|result</|
|00002f40| 70 3e 0a 3c 70 3e 20 20 | 20 20 69 66 20 64 62 72 |p>.<p>  |  if dbr|
|00002f50| 65 73 75 6c 74 20 69 73 | 20 6e 6f 74 20 61 20 6e |esult is| not a n|
|00002f60| 75 6d 62 65 72 20 74 68 | 65 6e 20 72 65 74 75 72 |umber th|en retur|
|00002f70| 6e 20 64 62 72 65 73 75 | 6c 74 3c 2f 70 3e 0a 3c |n dbresu|lt</p>.<|
|00002f80| 70 3e 20 20 20 20 65 6c | 73 65 3c 2f 70 3e 0a 3c |p>    el|se</p>.<|
|00002f90| 70 3e 20 20 20 20 20 20 | 70 75 74 20 64 62 72 65 |p>      |put dbre|
|00002fa0| 73 75 6c 74 20 69 6e 74 | 6f 20 63 75 72 73 6f 72 |sult int|o cursor|
|00002fb0| 69 64 3c 2f 70 3e 0a 3c | 70 3e 20 20 20 20 20 20 |id</p>.<|p>      |
|00002fc0| 70 75 74 20 72 65 76 64 | 62 5f 72 65 63 6f 72 64 |put revd|b_record|
|00002fd0| 63 6f 75 6e 74 28 63 75 | 72 73 6f 72 69 64 29 20 |count(cu|rsorid) |
|00002fe0| 69 6e 74 6f 20 6e 75 6d | 72 6f 77 73 3c 2f 70 3e |into num|rows</p>|
|00002ff0| 0a 3c 70 3e 20 20 20 20 | 20 20 70 75 74 20 72 65 |.<p>    |  put re|
|00003000| 76 64 62 5f 63 6f 6c 75 | 6d 6e 63 6f 75 6e 74 28 |vdb_colu|mncount(|
|00003010| 63 75 72 73 6f 72 69 64 | 29 20 69 6e 74 6f 20 6e |cursorid|) into n|
|00003020| 75 6d 63 6f 6c 75 6d 6e | 73 3c 2f 70 3e 0a 3c 70 |umcolumn|s</p>.<p|
|00003030| 3e 20 20 20 20 20 20 70 | 75 74 20 72 65 76 64 62 |>      p|ut revdb|
|00003040| 5f 63 6f 6c 75 6d 6e 74 | 79 70 65 73 28 63 75 72 |_columnt|ypes(cur|
|00003050| 73 6f 72 69 64 29 20 69 | 6e 74 6f 20 63 6f 6c 74 |sorid) i|nto colt|
|00003060| 79 70 65 73 3c 2f 70 3e | 0a 3c 70 3e 20 20 20 20 |ypes</p>|.<p>    |
|00003070| 20 20 64 69 73 70 6c 61 | 79 72 65 73 75 6c 74 73 |  displa|yresults|
|00003080| 65 74 20 63 75 72 73 6f | 72 69 64 3c 2f 70 3e 0a |et curso|rid</p>.|
|00003090| 3c 70 3e 20 20 20 20 20 | 20 69 66 20 30 20 26 67 |<p>     | if 0 &g|
|000030a0| 74 3b 20 6e 75 6d 72 6f | 77 73 20 74 68 65 6e 20 |t; numro|ws then |
|000030b0| 70 75 74 20 74 68 65 20 | 72 65 73 75 6c 74 20 69 |put the |result i|
|000030c0| 6e 74 6f 20 6e 75 6d 72 | 6f 77 73 3c 2f 70 3e 0a |nto numr|ows</p>.|
|000030d0| 3c 70 3e 20 20 20 20 20 | 20 72 65 74 75 72 6e 20 |<p>     | return |
|000030e0| 22 51 75 65 72 79 20 4f | 4b 2e 20 4e 65 77 20 52 |"Query O|K. New R|
|000030f0| 65 73 75 6c 74 53 65 74 | 20 49 44 20 22 26 61 6d |esultSet| ID "&am|
|00003100| 70 3b 26 61 6d 70 3b 63 | 75 72 73 6f 72 69 64 26 |p;&amp;c|ursorid&|
|00003110| 61 6d 70 3b 26 61 6d 70 | 3b 22 63 72 65 61 74 65 |amp;&amp|;"create|
|00003120| 64 2e 22 26 61 6d 70 3b | 63 72 26 61 6d 70 3b 20 |d."&amp;|cr&amp; |
|00003130| 5c 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 20 20 20 |\</p>.<p|>       |
|00003140| 20 20 20 22 4e 75 6d 62 | 65 72 20 6f 72 20 72 6f |   "Numb|er or ro|
|00003150| 77 73 20 72 65 74 72 69 | 65 76 65 64 3a 22 26 61 |ws retri|eved:"&a|
|00003160| 6d 70 3b 6e 75 6d 72 6f | 77 73 26 61 6d 70 3b 26 |mp;numro|ws&amp;&|
|00003170| 61 6d 70 3b 22 4e 75 6d | 62 65 72 20 6f 66 20 63 |amp;"Num|ber of c|
|00003180| 6f 6c 75 6d 6e 73 3a 22 | 26 61 6d 70 3b 26 61 6d |olumns:"|&amp;&am|
|00003190| 70 3b 6e 75 6d 63 6f 6c | 75 6d 6e 73 20 26 61 6d |p;numcol|umns &am|
|000031a0| 70 3b 20 63 72 26 61 6d | 70 3b 20 5c 3c 2f 70 3e |p; cr&am|p; \</p>|
|000031b0| 0a 3c 70 3e 20 20 20 20 | 20 20 20 20 20 20 22 63 |.<p>    |      "c|
|000031c0| 6f 6c 75 6d 6e 20 74 79 | 70 65 73 3a 22 26 61 6d |olumn ty|pes:"&am|
|000031d0| 70 3b 63 6f 6c 74 79 70 | 65 73 3c 2f 70 3e 0a 3c |p;coltyp|es</p>.<|
|000031e0| 70 3e 20 20 20 20 65 6e | 64 20 69 66 3c 2f 70 3e |p>    en|d if</p>|
|000031f0| 0a 3c 70 3e 20 20 65 6c | 73 65 3c 2f 70 3e 0a 3c |.<p>  el|se</p>.<|
|00003200| 70 3e 20 20 20 20 70 75 | 74 20 72 65 76 64 62 5f |p>    pu|t revdb_|
|00003210| 65 78 65 63 75 74 65 28 | 74 68 65 63 6f 6e 6e 65 |execute(|theconne|
|00003220| 63 74 69 6f 6e 2c 74 68 | 65 71 75 65 72 79 2c 22 |ction,th|equery,"|
|00003230| 74 70 61 72 61 6d 73 22 | 29 20 69 6e 74 6f 20 64 |tparams"|) into d|
|00003240| 62 72 65 73 75 6c 74 3c | 2f 70 3e 0a 3c 70 3e 20 |bresult<|/p>.<p> |
|00003250| 20 20 20 69 66 20 64 62 | 72 65 73 75 6c 74 20 69 |   if db|result i|
|00003260| 73 20 61 20 6e 75 6d 62 | 65 72 20 74 68 65 6e 3c |s a numb|er then<|
|00003270| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 20 20 70 75 74 |/p>.<p> |     put|
|00003280| 20 64 62 72 65 73 75 6c | 74 20 69 6e 74 6f 20 72 | dbresul|t into r|
|00003290| 6f 77 73 61 66 66 65 63 | 74 65 64 3c 2f 70 3e 0a |owsaffec|ted</p>.|
|000032a0| 3c 70 3e 20 20 20 20 20 | 20 70 75 74 20 22 51 75 |<p>     | put "Qu|
|000032b0| 65 72 79 20 4f 4b 2e 22 | 26 61 6d 70 3b 63 72 26 |ery OK."|&amp;cr&|
|000032c0| 61 6d 70 3b 22 4e 75 6d | 62 65 72 20 6f 66 20 72 |amp;"Num|ber of r|
|000032d0| 6f 77 73 20 61 66 66 65 | 63 74 65 64 3a 22 26 61 |ows affe|cted:"&a|
|000032e0| 6d 70 3b 26 61 6d 70 3b | 72 6f 77 73 61 66 66 65 |mp;&amp;|rowsaffe|
|000032f0| 63 74 65 64 20 69 6e 74 | 6f 20 74 72 65 73 75 6c |cted int|o tresul|
|00003300| 74 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 20 20 67 |t</p>.<p|>      g|
|00003310| 65 74 20 72 65 76 64 62 | 5f 63 6f 6d 6d 69 74 28 |et revdb|_commit(|
|00003320| 74 68 65 63 6f 6e 6e 65 | 63 74 69 6f 6e 29 3c 2f |theconne|ction)</|
|00003330| 70 3e 0a 3c 70 3e 20 20 | 20 20 65 6c 73 65 20 70 |p>.<p>  |  else p|
|00003340| 75 74 20 64 62 72 65 73 | 75 6c 74 20 69 6e 74 6f |ut dbres|ult into|
|00003350| 20 74 72 65 73 75 6c 74 | 3c 2f 70 3e 0a 3c 70 3e | tresult|</p>.<p>|
|00003360| 20 20 65 6e 64 20 69 66 | 3c 2f 70 3e 0a 3c 70 3e |  end if|</p>.<p>|
|00003370| 20 20 72 65 74 75 72 6e | 20 74 72 65 73 75 6c 74 |  return| tresult|
|00003380| 3c 2f 70 3e 0a 3c 70 3e | 65 6e 64 20 64 6f 71 75 |</p>.<p>|end doqu|
|00003390| 65 72 79 3c 2f 70 3e 0a | 3c 70 3e 3c 2f 70 3e 0a |ery</p>.|<p></p>.|
|000033a0| 3c 70 3e 6f 6e 20 63 6c | 6f 73 65 64 61 74 61 63 |<p>on cl|osedatac|
|000033b0| 6f 6e 6e 65 63 74 69 6f | 6e 20 64 62 63 6f 6e 6e |onnectio|n dbconn|
|000033c0| 65 63 74 69 6f 6e 3c 2f | 70 3e 0a 3c 70 3e 20 20 |ection</|p>.<p>  |
|000033d0| 70 75 74 20 72 65 76 64 | 62 5f 63 75 72 73 6f 72 |put revd|b_cursor|
|000033e0| 73 28 64 62 63 6f 6e 6e | 65 63 74 69 6f 6e 29 20 |s(dbconn|ection) |
|000033f0| 69 6e 74 6f 20 63 75 72 | 73 6f 72 6c 69 73 74 3c |into cur|sorlist<|
|00003400| 2f 70 3e 0a 3c 70 3e 20 | 20 69 66 20 69 74 65 6d |/p>.<p> | if item|
|00003410| 20 31 20 6f 66 20 63 75 | 72 73 6f 72 6c 69 73 74 | 1 of cu|rsorlist|
|00003420| 20 69 73 20 6e 6f 74 20 | 22 72 65 76 64 62 65 72 | is not |"revdber|
|00003430| 72 22 20 74 68 65 6e 3c | 2f 70 3e 0a 3c 70 3e 20 |r" then<|/p>.<p> |
|00003440| 20 20 20 72 65 70 65 61 | 74 20 66 6f 72 20 65 61 |   repea|t for ea|
|00003450| 63 68 20 69 74 65 6d 20 | 69 20 69 6e 20 63 75 72 |ch item |i in cur|
|00003460| 73 6f 72 6c 69 73 74 3c | 2f 70 3e 0a 3c 70 3e 20 |sorlist<|/p>.<p> |
|00003470| 20 20 20 20 20 64 65 6c | 65 74 65 20 73 74 61 63 |     del|ete stac|
|00003480| 6b 20 28 22 64 61 74 61 | 72 65 73 75 6c 74 2d 22 |k ("data|result-"|
|00003490| 26 61 6d 70 3b 69 29 3c | 2f 70 3e 0a 3c 70 3e 20 |&amp;i)<|/p>.<p> |
|000034a0| 20 20 20 65 6e 64 20 72 | 65 70 65 61 74 3c 2f 70 |   end r|epeat</p|
|000034b0| 3e 0a 3c 70 3e 20 20 65 | 6e 64 20 69 66 3c 2f 70 |>.<p>  e|nd if</p|
|000034c0| 3e 0a 3c 70 3e 20 20 70 | 75 74 20 72 65 76 64 62 |>.<p>  p|ut revdb|
|000034d0| 5f 64 69 73 63 6f 6e 6e | 65 63 74 28 64 62 63 6f |_disconn|ect(dbco|
|000034e0| 6e 6e 65 63 74 69 6f 6e | 29 20 69 6e 74 6f 20 64 |nnection|) into d|
|000034f0| 62 72 65 73 75 6c 74 3c | 2f 70 3e 0a 3c 70 3e 65 |bresult<|/p>.<p>e|
|00003500| 6e 64 20 63 6c 6f 73 65 | 64 61 74 61 63 6f 6e 6e |nd close|dataconn|
|00003510| 65 63 74 69 6f 6e 3c 2f | 70 3e 0a 3c 70 3e 3c 2f |ection</|p>.<p></|
|00003520| 70 3e 0a 3c 70 3e 6f 6e | 20 63 6c 6f 73 65 63 75 |p>.<p>on| closecu|
|00003530| 72 73 6f 72 63 6f 6e 6e | 65 63 74 69 6f 6e 20 64 |rsorconn|ection d|
|00003540| 62 63 75 72 73 6f 72 3c | 2f 70 3e 0a 3c 70 3e 20 |bcursor<|/p>.<p> |
|00003550| 20 70 75 74 20 72 65 76 | 64 62 5f 63 6c 6f 73 65 | put rev|db_close|
|00003560| 63 75 72 73 6f 72 28 64 | 62 63 75 72 73 6f 72 29 |cursor(d|bcursor)|
|00003570| 20 69 6e 74 6f 20 64 62 | 72 65 73 75 6c 74 3c 2f | into db|result</|
|00003580| 70 3e 0a 3c 70 3e 65 6e | 64 20 63 6c 6f 73 65 63 |p>.<p>en|d closec|
|00003590| 75 72 73 6f 72 63 6f 6e | 6e 65 63 74 69 6f 6e 3c |ursorcon|nection<|
|000035a0| 2f 70 3e 0a 3c 70 3e 3c | 2f 70 3e 0a 3c 70 3e 6f |/p>.<p><|/p>.<p>o|
|000035b0| 6e 20 70 72 65 4f 70 65 | 6e 53 74 61 63 6b 3c 2f |n preOpe|nStack</|
|000035c0| 70 3e 0a 3c 70 3e 20 20 | 73 65 74 20 74 68 65 20 |p>.<p>  |set the |
|000035d0| 6d 69 6e 57 69 64 74 68 | 20 6f 66 20 74 68 69 73 |minWidth| of this|
|000035e0| 20 73 74 61 63 6b 20 74 | 6f 20 34 30 32 3c 2f 70 | stack t|o 402</p|
|000035f0| 3e 0a 3c 70 3e 20 20 73 | 65 74 20 74 68 65 20 6d |>.<p>  s|et the m|
|00003600| 61 78 57 69 64 74 68 20 | 6f 66 20 74 68 69 73 20 |axWidth |of this |
|00003610| 73 74 61 63 6b 20 74 6f | 20 34 30 32 3c 2f 70 3e |stack to| 402</p>|
|00003620| 0a 3c 70 3e 65 6e 64 20 | 70 72 65 4f 70 65 6e 53 |.<p>end |preOpenS|
|00003630| 74 61 63 6b 3c 2f 70 3e | 0a 3c 70 3e 3c 2f 70 3e |tack</p>|.<p></p>|
|00003640| 0a 3c 70 3e 6f 6e 20 6f | 70 65 6e 53 74 61 63 6b |.<p>on o|penStack|
|00003650| 3c 2f 70 3e 0a 3c 70 3e | 20 20 69 66 20 74 68 65 |</p>.<p>|  if the|
|00003660| 20 70 6c 61 74 66 6f 72 | 6d 20 69 73 20 22 4d 61 | platfor|m is "Ma|
|00003670| 63 4f 53 22 20 61 6e 64 | 20 63 68 61 72 20 31 20 |cOS" and| char 1 |
|00003680| 6f 66 20 74 68 65 20 73 | 79 73 74 65 6d 56 65 72 |of the s|ystemVer|
|00003690| 73 69 6f 6e 20 69 73 20 | 22 31 22 20 74 68 65 6e |sion is |"1" then|
|000036a0| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 61 6e 73 77 |</p>.<p>|    answ|
|000036b0| 65 72 20 65 72 72 6f 72 | 20 22 4f 6e 6c 79 20 4d |er error| "Only M|
|000036c0| 79 53 51 4c 20 61 6e 64 | 20 56 61 6c 65 6e 74 69 |ySQL and| Valenti|
|000036d0| 6e 61 20 64 61 74 61 62 | 61 73 65 73 20 61 72 65 |na datab|ases are|
|000036e0| 20 63 75 72 72 65 6e 74 | 6c 79 20 73 75 70 70 6f | current|ly suppo|
|000036f0| 72 74 65 64 20 6f 6e 20 | 4f 53 20 58 20 64 75 65 |rted on |OS X due|
|00003700| 20 74 6f 20 64 72 69 76 | 65 72 20 69 73 73 75 65 | to driv|er issue|
|00003710| 73 2e 22 20 77 69 74 68 | 20 22 4f 4b 22 3c 2f 70 |s." with| "OK"</p|
|00003720| 3e 0a 3c 70 3e 20 20 65 | 6e 64 20 69 66 3c 2f 70 |>.<p>  e|nd if</p|
|00003730| 3e 0a 3c 70 3e 65 6e 64 | 20 6f 70 65 6e 53 74 61 |>.<p>end| openSta|
|00003740| 63 6b 3c 2f 70 3e 0a 3c | 70 3e 3c 2f 70 3e 0a 3c |ck</p>.<|p></p>.<|
|00003750| 70 3e 6f 6e 20 70 72 65 | 4f 70 65 6e 43 61 72 64 |p>on pre|OpenCard|
|00003760| 3c 2f 70 3e 0a 3c 70 3e | 20 20 70 75 74 20 74 68 |</p>.<p>|  put th|
|00003770| 65 20 72 65 63 74 20 6f | 66 20 74 68 69 73 20 73 |e rect o|f this s|
|00003780| 74 61 63 6b 20 69 6e 74 | 6f 20 74 52 65 63 74 3c |tack int|o tRect<|
|00003790| 2f 70 3e 0a 3c 70 3e 20 | 20 73 65 74 20 74 68 65 |/p>.<p> | set the|
|000037a0| 20 72 65 63 74 20 6f 66 | 20 74 68 69 73 20 73 74 | rect of| this st|
|000037b0| 61 63 6b 20 74 6f 20 69 | 74 65 6d 20 31 20 74 6f |ack to i|tem 1 to|
|000037c0| 20 33 20 6f 66 20 74 52 | 65 63 74 2c 69 74 65 6d | 3 of tR|ect,item|
|000037d0| 20 32 20 6f 66 20 74 52 | 65 63 74 20 2b 20 74 68 | 2 of tR|ect + th|
|000037e0| 65 20 63 52 45 56 4d 69 | 6e 48 65 69 67 68 74 20 |e cREVMi|nHeight |
|000037f0| 6f 66 20 74 68 69 73 20 | 63 64 3c 2f 70 3e 0a 3c |of this |cd</p>.<|
|00003800| 70 3e 65 6e 64 20 70 72 | 65 4f 70 65 6e 43 61 72 |p>end pr|eOpenCar|
|00003810| 64 3c 2f 70 3e 0a 3c 70 | 3e 3c 2f 70 3e 0a 3c 70 |d</p>.<p|></p>.<p|
|00003820| 3e 6f 6e 20 63 6c 6f 73 | 65 63 6f 6e 6e 65 63 74 |>on clos|econnect|
|00003830| 69 6f 6e 73 3c 2f 70 3e | 0a 3c 70 3e 20 20 70 75 |ions</p>|.<p>  pu|
|00003840| 74 20 72 65 76 64 62 5f | 63 6f 6e 6e 65 63 74 69 |t revdb_|connecti|
|00003850| 6f 6e 73 28 29 20 69 6e | 74 6f 20 63 6f 6e 6e 65 |ons() in|to conne|
|00003860| 63 74 69 6f 6e 6c 69 73 | 74 3c 2f 70 3e 0a 3c 70 |ctionlis|t</p>.<p|
|00003870| 3e 20 20 72 65 70 65 61 | 74 20 66 6f 72 20 65 61 |>  repea|t for ea|
|00003880| 63 68 20 69 74 65 6d 20 | 69 20 69 6e 20 63 6f 6e |ch item |i in con|
|00003890| 6e 65 63 74 69 6f 6e 6c | 69 73 74 3c 2f 70 3e 0a |nectionl|ist</p>.|
|000038a0| 3c 70 3e 20 20 20 20 64 | 65 6c 65 74 65 20 73 74 |<p>    d|elete st|
|000038b0| 61 63 6b 20 28 22 64 61 | 74 61 63 6f 6e 6e 65 63 |ack ("da|taconnec|
|000038c0| 74 69 6f 6e 2d 22 26 61 | 6d 70 3b 69 29 3c 2f 70 |tion-"&a|mp;i)</p|
|000038d0| 3e 0a 3c 70 3e 20 20 65 | 6e 64 20 72 65 70 65 61 |>.<p>  e|nd repea|
|000038e0| 74 3c 2f 70 3e 0a 3c 70 | 3e 65 6e 64 20 63 6c 6f |t</p>.<p|>end clo|
|000038f0| 73 65 63 6f 6e 6e 65 63 | 74 69 6f 6e 73 3c 2f 70 |seconnec|tions</p|
|00003900| 3e 0a 3c 70 3e 3c 2f 70 | 3e 0a 3c 70 3e 6f 6e 20 |>.<p></p|>.<p>on |
|00003910| 64 69 73 70 6c 61 79 72 | 65 73 75 6c 74 73 65 74 |displayr|esultset|
|00003920| 20 63 75 72 73 6f 72 69 | 64 3c 2f 70 3e 0a 3c 70 | cursori|d</p>.<p|
|00003930| 3e 20 20 6c 6f 63 61 6c | 20 63 6f 6c 6e 61 6d 65 |>  local| colname|
|00003940| 73 2c 63 6f 6c 6c 65 6e | 67 74 68 73 2c 74 69 74 |s,collen|gths,tit|
|00003950| 6c 65 73 65 70 2c 63 6f | 6c 63 6f 75 6e 74 2c 72 |lesep,co|lcount,r|
|00003960| 65 73 75 6c 74 64 61 74 | 61 3c 2f 70 3e 0a 3c 70 |esultdat|a</p>.<p|
|00003970| 3e 20 20 62 72 65 61 6b | 70 6f 69 6e 74 3c 2f 70 |>  break|point</p|
|00003980| 3e 0a 3c 70 3e 20 20 70 | 75 74 20 72 65 76 64 62 |>.<p>  p|ut revdb|
|00003990| 5f 63 6f 6c 75 6d 6e 6e | 61 6d 65 73 28 63 75 72 |_columnn|ames(cur|
|000039a0| 73 6f 72 69 64 29 20 69 | 6e 74 6f 20 63 6f 6c 6e |sorid) i|nto coln|
|000039b0| 61 6d 65 73 3c 2f 70 3e | 0a 3c 70 3e 20 20 70 75 |ames</p>|.<p>  pu|
|000039c0| 74 20 6e 75 6d 62 65 72 | 20 6f 66 20 69 74 65 6d |t number| of item|
|000039d0| 73 20 6f 66 20 63 6f 6c | 6e 61 6d 65 73 20 69 6e |s of col|names in|
|000039e0| 74 6f 20 63 6f 6c 63 6f | 75 6e 74 3c 2f 70 3e 0a |to colco|unt</p>.|
|000039f0| 3c 70 3e 20 20 70 75 74 | 20 72 65 76 64 62 5f 63 |<p>  put| revdb_c|
|00003a00| 6f 6c 75 6d 6e 6c 65 6e | 67 74 68 73 28 63 75 72 |olumnlen|gths(cur|
|00003a10| 73 6f 72 69 64 29 20 69 | 6e 74 6f 20 63 6f 6c 6c |sorid) i|nto coll|
|00003a20| 65 6e 67 74 68 73 3c 2f | 70 3e 0a 3c 70 3e 20 20 |engths</|p>.<p>  |
|00003a30| 73 70 6c 69 74 20 63 6f | 6c 6e 61 6d 65 73 20 62 |split co|lnames b|
|00003a40| 79 20 63 6f 6d 6d 61 3c | 2f 70 3e 0a 3c 70 3e 20 |y comma<|/p>.<p> |
|00003a50| 20 73 70 6c 69 74 20 63 | 6f 6c 6c 65 6e 67 74 68 | split c|ollength|
|00003a60| 73 20 62 79 20 63 6f 6d | 6d 61 3c 2f 70 3e 0a 3c |s by com|ma</p>.<|
|00003a70| 70 3e 20 20 72 65 70 65 | 61 74 20 77 69 74 68 20 |p>  repe|at with |
|00003a80| 69 20 3d 20 31 20 74 6f | 20 63 6f 6c 63 6f 75 6e |i = 1 to| colcoun|
|00003a90| 74 20 2d 2d 74 72 75 6e | 63 61 74 65 20 63 6f 6c |t --trun|cate col|
|00003aa0| 75 6d 6e 20 6c 65 6e 67 | 74 68 73 20 69 6e 20 63 |umn leng|ths in c|
|00003ab0| 61 73 65 20 6f 66 20 6c | 61 72 67 65 20 76 61 6c |ase of l|arge val|
|00003ac0| 75 65 73 3c 2f 70 3e 0a | 3c 70 3e 20 20 20 20 69 |ues</p>.|<p>    i|
|00003ad0| 66 20 63 6f 6c 6c 65 6e | 67 74 68 73 5b 69 5d 20 |f collen|gths[i] |
|00003ae0| 26 67 74 3b 20 33 30 20 | 74 68 65 6e 20 70 75 74 |&gt; 30 |then put|
|00003af0| 20 33 30 20 69 6e 74 6f | 20 63 6f 6c 6c 65 6e 67 | 30 into| colleng|
|00003b00| 74 68 73 5b 69 5d 3c 2f | 70 3e 0a 3c 70 3e 20 20 |ths[i]</|p>.<p>  |
|00003b10| 20 20 61 64 64 20 35 20 | 74 6f 20 63 6f 6c 6c 65 |  add 5 |to colle|
|00003b20| 6e 67 74 68 73 5b 69 5d | 20 2d 2d 20 61 64 64 20 |ngths[i]| -- add |
|00003b30| 61 20 6c 69 74 74 6c 65 | 20 65 78 74 72 61 20 70 |a little| extra p|
|00003b40| 61 64 64 69 6e 67 3c 2f | 70 3e 0a 3c 70 3e 20 20 |adding</|p>.<p>  |
|00003b50| 65 6e 64 20 72 65 70 65 | 61 74 3c 2f 70 3e 0a 3c |end repe|at</p>.<|
|00003b60| 70 3e 20 20 72 65 70 65 | 61 74 20 77 69 74 68 20 |p>  repe|at with |
|00003b70| 69 20 3d 20 31 20 74 6f | 20 63 6f 6c 63 6f 75 6e |i = 1 to| colcoun|
|00003b80| 74 3c 2f 70 3e 0a 3c 70 | 3e 20 20 20 20 70 75 74 |t</p>.<p|>    put|
|00003b90| 20 66 6f 72 6d 61 74 28 | 22 25 2d 22 26 61 6d 70 | format(|"%-"&amp|
|00003ba0| 3b 63 6f 6c 6c 65 6e 67 | 74 68 73 5b 69 5d 26 61 |;colleng|ths[i]&a|
|00003bb0| 6d 70 3b 22 2e 33 30 73 | 22 2c 74 6f 55 70 70 65 |mp;".30s|",toUppe|
|00003bc0| 72 28 63 6f 6c 6e 61 6d | 65 73 5b 69 5d 29 29 20 |r(colnam|es[i])) |
|00003bd0| 61 66 74 65 72 20 72 65 | 73 75 6c 74 64 61 74 61 |after re|sultdata|
|00003be0| 3c 2f 70 3e 0a 3c 70 3e | 20 20 65 6e 64 20 72 65 |</p>.<p>|  end re|
|00003bf0| 70 65 61 74 3c 2f 70 3e | 0a 3c 70 3e 20 20 70 75 |peat</p>|.<p>  pu|
|00003c00| 74 20 72 65 74 75 72 6e | 20 61 66 74 65 72 20 72 |t return| after r|
|00003c10| 65 73 75 6c 74 64 61 74 | 61 3c 2f 70 3e 0a 3c 70 |esultdat|a</p>.<p|
|00003c20| 3e 20 20 72 65 70 65 61 | 74 20 77 69 74 68 20 69 |>  repea|t with i|
|00003c30| 20 3d 20 31 20 74 6f 20 | 33 32 3c 2f 70 3e 0a 3c | = 1 to |32</p>.<|
|00003c40| 70 3e 20 20 20 20 70 75 | 74 20 22 2d 22 20 61 66 |p>    pu|t "-" af|
|00003c50| 74 65 72 20 74 69 74 6c | 65 73 65 70 3c 2f 70 3e |ter titl|esep</p>|
|00003c60| 0a 3c 70 3e 20 20 65 6e | 64 20 72 65 70 65 61 74 |.<p>  en|d repeat|
|00003c70| 3c 2f 70 3e 0a 3c 70 3e | 20 20 72 65 70 65 61 74 |</p>.<p>|  repeat|
|00003c80| 20 77 69 74 68 20 69 20 | 3d 20 31 20 74 6f 20 63 | with i |= 1 to c|
|00003c90| 6f 6c 63 6f 75 6e 74 3c | 2f 70 3e 0a 3c 70 3e 20 |olcount<|/p>.<p> |
|00003ca0| 20 20 20 70 75 74 20 63 | 68 61 72 20 31 20 74 6f |   put c|har 1 to|
|00003cb0| 20 63 6f 6c 6c 65 6e 67 | 74 68 73 5b 69 5d 20 6f | colleng|ths[i] o|
|00003cc0| 66 20 74 69 74 6c 65 73 | 65 70 20 61 66 74 65 72 |f titles|ep after|
|00003cd0| 20 72 65 73 75 6c 74 64 | 61 74 61 3c 2f 70 3e 0a | resultd|ata</p>.|
|00003ce0| 3c 70 3e 20 20 65 6e 64 | 20 72 65 70 65 61 74 3c |<p>  end| repeat<|
|00003cf0| 2f 70 3e 0a 3c 70 3e 20 | 20 70 75 74 20 30 20 69 |/p>.<p> | put 0 i|
|00003d00| 6e 74 6f 20 72 6f 77 73 | 72 65 74 72 69 65 76 65 |nto rows|retrieve|
|00003d10| 64 3c 2f 70 3e 0a 3c 70 | 3e 20 20 72 65 70 65 61 |d</p>.<p|>  repea|
|00003d20| 74 20 77 68 69 6c 65 20 | 72 65 76 64 62 5f 69 73 |t while |revdb_is|
|00003d30| 65 6f 66 28 63 75 72 73 | 6f 72 69 64 29 20 69 73 |eof(curs|orid) is|
|00003d40| 20 6e 6f 74 20 74 72 75 | 65 3c 2f 70 3e 0a 3c 70 | not tru|e</p>.<p|
|00003d50| 3e 20 20 20 20 61 64 64 | 20 31 20 74 6f 20 72 6f |>    add| 1 to ro|
|00003d60| 77 73 72 65 74 72 69 65 | 76 65 64 3c 2f 70 3e 0a |wsretrie|ved</p>.|
|00003d70| 3c 70 3e 20 20 20 20 70 | 75 74 20 72 65 74 75 72 |<p>    p|ut retur|
|00003d80| 6e 20 61 66 74 65 72 20 | 72 65 73 75 6c 74 64 61 |n after |resultda|
|00003d90| 74 61 3c 2f 70 3e 0a 3c | 70 3e 20 20 20 20 72 65 |ta</p>.<|p>    re|
|00003da0| 70 65 61 74 20 77 69 74 | 68 20 69 20 3d 20 31 20 |peat wit|h i = 1 |
|00003db0| 74 6f 20 63 6f 6c 63 6f | 75 6e 74 3c 2f 70 3e 0a |to colco|unt</p>.|
|00003dc0| 3c 70 3e 20 20 20 20 20 | 20 69 66 20 72 65 76 64 |<p>     | if revd|
|00003dd0| 62 5f 63 6f 6c 75 6d 6e | 69 73 6e 75 6c 6c 28 63 |b_column|isnull(c|
|00003de0| 75 72 73 6f 72 69 64 2c | 69 29 20 69 73 20 74 72 |ursorid,|i) is tr|
|00003df0| 75 65 20 74 68 65 6e 20 | 70 75 74 20 66 6f 72 6d |ue then |put form|
|00003e00| 61 74 28 22 25 2d 22 26 | 61 6d 70 3b 63 6f 6c 6c |at("%-"&|amp;coll|
|00003e10| 65 6e 67 74 68 73 5b 69 | 5d 26 61 6d 70 3b 22 2e |engths[i|]&amp;".|
|00003e20| 33 30 73 22 2c 22 4e 55 | 4c 4c 22 29 20 61 66 74 |30s","NU|LL") aft|
|00003e30| 65 72 20 72 65 73 75 6c | 74 64 61 74 61 3c 2f 70 |er resul|tdata</p|
|00003e40| 3e 0a 3c 70 3e 20 20 20 | 20 20 20 65 6c 73 65 20 |>.<p>   |   else |
|00003e50| 70 75 74 20 66 6f 72 6d | 61 74 28 22 25 2d 22 26 |put form|at("%-"&|
|00003e60| 61 6d 70 3b 63 6f 6c 6c | 65 6e 67 74 68 73 5b 69 |amp;coll|engths[i|
|00003e70| 5d 26 61 6d 70 3b 22 2e | 33 30 73 22 2c 72 65 76 |]&amp;".|30s",rev|
|00003e80| 64 62 5f 63 6f 6c 75 6d | 6e 62 79 6e 75 6d 62 65 |db_colum|nbynumbe|
|00003e90| 72 28 63 75 72 73 6f 72 | 69 64 2c 69 29 29 20 61 |r(cursor|id,i)) a|
|00003ea0| 66 74 65 72 20 72 65 73 | 75 6c 74 64 61 74 61 3c |fter res|ultdata<|
|00003eb0| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 65 6e 64 20 72 |/p>.<p> |   end r|
|00003ec0| 65 70 65 61 74 3c 2f 70 | 3e 0a 3c 70 3e 20 20 20 |epeat</p|>.<p>   |
|00003ed0| 20 67 65 74 20 72 65 76 | 64 62 5f 6d 6f 76 65 6e | get rev|db_moven|
|00003ee0| 65 78 74 28 63 75 72 73 | 6f 72 69 64 29 3c 2f 70 |ext(curs|orid)</p|
|00003ef0| 3e 0a 3c 70 3e 20 20 65 | 6e 64 20 72 65 70 65 61 |>.<p>  e|nd repea|
|00003f00| 74 3c 2f 70 3e 0a 3c 70 | 3e 20 20 63 6c 6f 6e 65 |t</p>.<p|>  clone|
|00003f10| 20 73 74 61 63 6b 20 22 | 64 61 74 61 72 65 73 75 | stack "|dataresu|
|00003f20| 6c 74 22 3c 2f 70 3e 0a | 3c 70 3e 20 20 70 75 74 |lt"</p>.|<p>  put|
|00003f30| 20 22 64 61 74 61 72 65 | 73 75 6c 74 2d 22 26 61 | "datare|sult-"&a|
|00003f40| 6d 70 3b 63 75 72 73 6f | 72 69 64 20 69 6e 74 6f |mp;curso|rid into|
|00003f50| 20 6e 73 74 61 63 6b 6e | 61 6d 65 3c 2f 70 3e 0a | nstackn|ame</p>.|
|00003f60| 3c 70 3e 20 20 73 65 74 | 20 74 68 65 20 6e 61 6d |<p>  set| the nam|
|00003f70| 65 20 6f 66 20 74 68 65 | 20 74 6f 70 73 74 61 63 |e of the| topstac|
|00003f80| 6b 20 74 6f 20 6e 73 74 | 61 63 6b 6e 61 6d 65 3c |k to nst|ackname<|
|00003f90| 2f 70 3e 0a 3c 70 3e 20 | 20 73 65 74 20 74 68 65 |/p>.<p> | set the|
|00003fa0| 20 6d 61 69 6e 73 74 61 | 63 6b 20 6f 66 20 73 74 | mainsta|ck of st|
|00003fb0| 61 63 6b 20 6e 73 74 61 | 63 6b 6e 61 6d 65 20 74 |ack nsta|ckname t|
|00003fc0| 6f 20 22 72 65 76 64 61 | 74 61 62 61 73 65 22 3c |o "revda|tabase"<|
|00003fd0| 2f 70 3e 0a 3c 70 3e 20 | 20 73 65 74 20 74 68 65 |/p>.<p> | set the|
|00003fe0| 20 74 69 74 6c 65 20 6f | 66 20 73 74 61 63 6b 20 | title o|f stack |
|00003ff0| 6e 73 74 61 63 6b 6e 61 | 6d 65 20 74 6f 20 6e 73 |nstackna|me to ns|
|00004000| 74 61 63 6b 6e 61 6d 65 | 3c 2f 70 3e 0a 3c 70 3e |tackname|</p>.<p>|
|00004010| 20 20 73 65 74 20 74 68 | 65 20 63 61 6e 74 4d 6f |  set th|e cantMo|
|00004020| 64 69 66 79 20 6f 66 20 | 73 74 61 63 6b 20 6e 73 |dify of |stack ns|
|00004030| 74 61 63 6b 6e 61 6d 65 | 20 74 6f 20 74 72 75 65 |tackname| to true|
|00004040| 3c 2f 70 3e 0a 3c 70 3e | 20 20 73 65 74 20 74 68 |</p>.<p>|  set th|
|00004050| 65 20 64 62 63 75 72 73 | 6f 72 69 64 20 6f 66 20 |e dbcurs|orid of |
|00004060| 73 74 61 63 6b 20 6e 73 | 74 61 63 6b 6e 61 6d 65 |stack ns|tackname|
|00004070| 20 74 6f 20 63 75 72 73 | 6f 72 69 64 3c 2f 70 3e | to curs|orid</p>|
|00004080| 0a 3c 70 3e 20 20 70 75 | 74 20 72 65 73 75 6c 74 |.<p>  pu|t result|
|00004090| 64 61 74 61 20 69 6e 74 | 6f 20 66 69 65 6c 64 20 |data int|o field |
|000040a0| 22 44 42 52 45 53 55 4c | 54 44 41 54 41 22 20 6f |"DBRESUL|TDATA" o|
|000040b0| 66 20 73 74 61 63 6b 20 | 6e 73 74 61 63 6b 6e 61 |f stack |nstackna|
|000040c0| 6d 65 3c 2f 70 3e 0a 3c | 70 3e 20 20 73 65 74 20 |me</p>.<|p>  set |
|000040d0| 74 68 65 20 62 61 63 6b | 67 72 6f 75 6e 64 63 6f |the back|groundco|
|000040e0| 6c 6f 72 20 6f 66 20 73 | 74 61 63 6b 20 6e 73 74 |lor of s|tack nst|
|000040f0| 61 63 6b 6e 61 6d 65 20 | 74 6f 20 74 68 65 20 62 |ackname |to the b|
|00004100| 61 63 6b 67 72 6f 75 6e | 64 63 6f 6c 6f 72 20 5c |ackgroun|dcolor \|
|00004110| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 20 20 6f 66 |</p>.<p>|      of|
|00004120| 20 73 74 61 63 6b 20 28 | 22 64 61 74 61 63 6f 6e | stack (|"datacon|
|00004130| 6e 65 63 74 69 6f 6e 2d | 22 26 61 6d 70 3b 72 65 |nection-|"&amp;re|
|00004140| 76 64 62 5f 63 75 72 73 | 6f 72 63 6f 6e 6e 65 63 |vdb_curs|orconnec|
|00004150| 74 69 6f 6e 28 63 75 72 | 73 6f 72 69 64 29 20 29 |tion(cur|sorid) )|
|00004160| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 20 20 72 65 |</p>.<p>|      re|
|00004170| 74 75 72 6e 20 72 6f 77 | 73 72 65 74 72 69 65 76 |turn row|sretriev|
|00004180| 65 64 3c 2f 70 3e 0a 3c | 70 3e 65 6e 64 20 64 69 |ed</p>.<|p>end di|
|00004190| 73 70 6c 61 79 72 65 73 | 75 6c 74 73 65 74 3c 2f |splayres|ultset</|
|000041a0| 70 3e 0a 3c 70 3e 3c 2f | 70 3e 0a 3c 70 3e 6c 6f |p>.<p></|p>.<p>lo|
|000041b0| 63 61 6c 20 72 61 6e 64 | 63 6f 6c 6f 72 63 6f 75 |cal rand|colorcou|
|000041c0| 6e 74 20 3d 20 30 3c 2f | 70 3e 0a 3c 70 3e 66 75 |nt = 0</|p>.<p>fu|
|000041d0| 6e 63 74 69 6f 6e 20 72 | 61 6e 64 63 6f 6c 6f 72 |nction r|andcolor|
|000041e0| 3c 2f 70 3e 0a 3c 70 3e | 20 20 69 66 20 72 61 6e |</p>.<p>|  if ran|
|000041f0| 64 63 6f 6c 6f 72 63 6f | 75 6e 74 20 69 73 20 38 |dcolorco|unt is 8|
|00004200| 20 74 68 65 6e 20 70 75 | 74 20 30 20 69 6e 74 6f | then pu|t 0 into|
|00004210| 20 72 61 6e 64 63 6f 6c | 6f 72 63 6f 75 6e 74 3c | randcol|orcount<|
|00004220| 2f 70 3e 0a 3c 70 3e 20 | 20 61 64 64 20 31 20 74 |/p>.<p> | add 1 t|
|00004230| 6f 20 72 61 6e 64 63 6f | 6c 6f 72 63 6f 75 6e 74 |o randco|lorcount|
|00004240| 3c 2f 70 3e 0a 3c 70 3e | 20 20 72 65 74 75 72 6e |</p>.<p>|  return|
|00004250| 20 6c 69 6e 65 20 72 61 | 6e 64 63 6f 6c 6f 72 63 | line ra|ndcolorc|
|00004260| 6f 75 6e 74 20 6f 66 20 | 74 68 65 20 63 6f 6c 6f |ount of |the colo|
|00004270| 72 6c 69 73 74 20 6f 66 | 20 74 68 69 73 20 73 74 |rlist of| this st|
|00004280| 61 63 6b 3c 2f 70 3e 0a | 3c 70 3e 65 6e 64 20 72 |ack</p>.|<p>end r|
|00004290| 61 6e 64 63 6f 6c 6f 72 | 3c 2f 70 3e 0a 3c 70 3e |andcolor|</p>.<p>|
|000042a0| 3c 2f 70 3e 0a 3c 70 3e | 6f 6e 20 6f 70 65 6e 53 |</p>.<p>|on openS|
|000042b0| 74 61 63 6b 3c 2f 70 3e | 0a 3c 70 3e 20 20 69 66 |tack</p>|.<p>  if|
|000042c0| 20 74 68 65 20 70 6c 61 | 74 66 6f 72 6d 20 69 73 | the pla|tform is|
|000042d0| 20 22 4d 61 63 4f 53 22 | 20 61 6e 64 20 63 68 61 | "MacOS"| and cha|
|000042e0| 72 20 31 20 6f 66 20 74 | 68 65 20 73 79 73 74 65 |r 1 of t|he syste|
|000042f0| 6d 56 65 72 73 69 6f 6e | 20 69 73 20 22 31 22 20 |mVersion| is "1" |
|00004300| 74 68 65 6e 3c 2f 70 3e | 0a 3c 70 3e 20 20 20 20 |then</p>|.<p>    |
|00004310| 61 6e 73 77 65 72 20 65 | 72 72 6f 72 20 22 4f 6e |answer e|rror "On|
|00004320| 6c 79 20 4d 79 53 51 4c | 20 61 6e 64 20 56 61 6c |ly MySQL| and Val|
|00004330| 65 6e 74 69 6e 61 20 64 | 61 74 61 62 61 73 65 73 |entina d|atabases|
|00004340| 20 61 72 65 20 73 75 70 | 70 6f 72 74 65 64 20 6f | are sup|ported o|
|00004350| 6e 20 4f 53 20 58 20 64 | 75 65 20 74 6f 20 64 72 |n OS X d|ue to dr|
|00004360| 69 76 65 72 20 69 73 73 | 75 65 73 2e 22 20 77 69 |iver iss|ues." wi|
|00004370| 74 68 20 22 4f 4b 22 3c | 2f 70 3e 0a 3c 70 3e 20 |th "OK"<|/p>.<p> |
|00004380| 20 65 6e 64 20 69 66 3c | 2f 70 3e 0a 3c 70 3e 65 | end if<|/p>.<p>e|
|00004390| 6e 64 20 6f 70 65 6e 53 | 74 61 63 6b 3c 2f 70 3e |nd openS|tack</p>|
|000043a0| 0a 3c 70 3e 3c 2f 70 3e | 18 00 12 63 52 45 56 47 |.<p></p>|...cREVG|
|000043b0| 65 6f 6d 65 74 72 79 43 | 61 63 68 65 00 00 00 00 |eometryC|ache....|
|000043c0| 01 08 73 74 61 63 6b 49 | 44 00 00 04 31 31 31 38 |..stackI|D...1118|
|000043d0| 04 00 00 03 ea 00 0a 54 | 65 78 74 20 44 61 74 61 |.......T|ext Data|
|000043e0| 00 00 00 09 40 00 00 00 | 00 80 00 00 00 00 00 01 |....@...|........|
|000043f0| 92 00 ce 00 00 00 01 0e | 63 52 45 56 4d 69 6e 48 |........|cREVMinH|
|00004400| 65 69 67 68 74 00 00 03 | 32 30 36 18 00 0c 63 52 |eight...|206...cR|
|00004410| 45 56 47 65 6e 65 72 61 | 6c 00 00 00 00 07 0f 73 |EVGenera|l......s|
|00004420| 63 72 69 70 74 43 68 65 | 63 6b 73 75 6d 00 00 10 |criptChe|cksum...|
|00004430| d4 1d 8c d9 8f 00 b2 04 | e9 80 09 98 ec f8 42 7e |........|......B~|
|00004440| 0a 62 6f 6f 6b 6d 61 72 | 6b 73 00 00 00 0c 68 61 |.bookmar|ks....ha|
|00004450| 6e 64 6c 65 72 4c 69 73 | 74 00 00 00 0b 74 65 6d |ndlerLis|t....tem|
|00004460| 70 53 63 72 69 70 74 00 | 00 00 0c 70 72 65 76 48 |pScript.|...prevH|
|00004470| 61 6e 64 6c 65 72 00 00 | 00 10 73 63 72 69 70 74 |andler..|..script|
|00004480| 53 65 6c 65 63 74 69 6f | 6e 00 00 0b 63 68 61 72 |Selectio|n...char|
|00004490| 20 31 20 74 6f 20 30 07 | 73 63 72 69 70 74 00 00 | 1 to 0.|script..|
|000044a0| 07 3c 70 3e 3c 2f 70 3e | 18 00 15 63 52 45 56 47 |.<p></p>|...cREVG|
|000044b0| 65 6f 6d 65 74 72 79 43 | 61 63 68 65 49 44 73 00 |eometryC|acheIDs.|
|000044c0| 00 00 00 11 0e 31 30 30 | 34 31 31 33 36 32 30 34 |.....100|41136204|
|000044d0| 37 33 00 00 04 31 31 30 | 39 0e 31 30 30 34 31 31 |73...110|9.100411|
|000044e0| 33 36 31 39 39 38 37 00 | 00 04 31 31 30 37 0e 31 |3619987.|..1107.1|
|000044f0| 30 30 34 31 31 33 36 31 | 39 34 34 32 00 00 04 31 |00411361|9442...1|
|00004500| 31 30 32 0e 31 30 30 34 | 31 31 33 36 31 39 38 37 |102.1004|11361987|
|00004510| 37 00 00 04 31 31 30 36 | 0e 31 30 30 34 31 32 30 |7...1106|.1004120|
|00004520| 30 37 30 31 34 35 00 00 | 04 31 30 38 31 0e 31 30 |070145..|.1081.10|
|00004530| 30 34 31 31 33 36 31 39 | 31 36 38 00 00 04 31 31 |04113619|168...11|
|00004540| 30 30 0e 31 30 30 34 31 | 31 33 36 32 30 31 30 31 |00.10041|13620101|
|00004550| 00 00 04 31 31 30 38 0e | 31 30 30 34 31 31 33 36 |...1108.|10041136|
|00004560| 32 37 37 38 36 00 00 04 | 31 30 32 30 0e 31 30 30 |27786...|1020.100|
|00004570| 34 31 31 33 36 31 39 37 | 36 38 00 00 04 31 31 30 |41136197|68...110|
|00004580| 35 0e 31 30 30 34 31 31 | 33 36 31 39 33 33 38 00 |5.100411|3619338.|
|00004590| 00 04 31 31 30 31 0e 31 | 30 30 34 31 31 33 36 32 |..1101.1|00411362|
|000045a0| 30 32 32 33 00 00 04 31 | 30 36 39 0e 31 30 30 34 |0223...1|069.1004|
|000045b0| 31 31 37 34 39 30 37 31 | 30 00 00 04 31 30 38 30 |11749071|0...1080|
|000045c0| 0e 31 30 30 34 31 31 33 | 36 31 39 36 35 39 00 00 |.1004113|619659..|
|000045d0| 04 31 31 30 34 0e 31 30 | 30 34 31 31 38 35 35 39 |.1104.10|04118559|
|000045e0| 34 31 31 00 00 04 31 30 | 38 32 0e 31 30 30 34 31 |411...10|82.10041|
|000045f0| 31 33 36 31 39 35 34 39 | 00 00 04 31 31 30 33 0e |13619549|...1103.|
|00004600| 31 30 30 34 31 31 32 35 | 37 33 30 34 38 00 00 04 |10041125|73048...|
|00004610| 31 30 32 34 0e 31 30 30 | 34 31 31 32 33 36 32 36 |1024.100|41123626|
|00004620| 39 33 00 00 04 31 30 32 | 32 18 00 12 63 52 45 56 |93...102|2...cREV|
|00004630| 47 65 6f 6d 65 74 72 79 | 43 61 63 68 65 00 00 00 |Geometry|Cache...|
|00004640| 00 02 06 6f 72 64 65 72 | 00 00 0e 31 30 30 34 31 |...order|...10041|
|00004650| 31 32 33 36 32 36 39 33 | 0a 06 74 6f 74 61 6c 00 |12362693|..total.|
|00004660| 00 02 31 37 07 00 00 04 | 00 07 00 00 04 3a 07 00 |..17....|.....:..|
|00004670| 00 04 2d 07 00 00 03 fc | 07 00 00 04 38 04 00 00 |..-.....|....8...|
|00004680| 03 ff 00 0c 42 69 6e 61 | 72 79 20 44 61 74 61 00 |....Bina|ry Data.|
|00004690| 00 00 09 40 00 00 00 00 | 80 00 00 00 00 00 01 92 |...@....|........|
|000046a0| 01 94 00 00 00 01 0e 63 | 52 45 56 4d 69 6e 48 65 |.......c|REVMinHe|
|000046b0| 69 67 68 74 00 00 03 34 | 30 34 18 00 0c 63 52 45 |ight...4|04...cRE|
|000046c0| 56 47 65 6e 65 72 61 6c | 00 00 00 00 05 0a 62 6f |VGeneral|......bo|
|000046d0| 6f 6b 6d 61 72 6b 73 00 | 00 00 0c 68 61 6e 64 6c |okmarks.|...handl|
|000046e0| 65 72 4c 69 73 74 00 00 | 0b 70 72 65 4f 70 65 6e |erList..|.preOpen|
|000046f0| 43 61 72 64 0b 74 65 6d | 70 53 63 72 69 70 74 00 |Card.tem|pScript.|
|00004700| 00 00 0c 70 72 65 76 48 | 61 6e 64 6c 65 72 00 00 |...prevH|andler..|
|00004710| 00 10 73 63 72 69 70 74 | 53 65 6c 65 63 74 69 6f |..script|Selectio|
|00004720| 6e 00 00 0f 63 68 61 72 | 20 31 35 30 20 74 6f 20 |n...char| 150 to |
|00004730| 31 34 39 18 00 15 63 52 | 45 56 47 65 6f 6d 65 74 |149...cR|EVGeomet|
|00004740| 72 79 43 61 63 68 65 49 | 44 73 00 00 00 00 1b 0e |ryCacheI|Ds......|
|00004750| 31 30 30 34 31 31 33 36 | 32 30 34 37 33 00 00 04 |10041136|20473...|
|00004760| 31 31 30 39 0e 31 30 30 | 34 31 32 32 36 33 36 36 |1109.100|41226366|
|00004770| 37 32 00 00 04 31 30 33 | 33 0e 31 30 30 34 31 32 |72...103|3.100412|
|00004780| 32 36 33 36 36 37 33 00 | 00 04 31 30 33 34 0e 31 |2636673.|..1034.1|
|00004790| 30 30 34 31 31 33 36 31 | 39 39 38 37 00 00 04 31 |00411361|9987...1|
|000047a0| 31 30 37 0e 31 30 30 34 | 31 31 32 39 37 36 39 31 |107.1004|11297691|
|000047b0| 31 00 00 04 31 30 32 36 | 0e 31 30 30 34 31 31 33 |1...1026|.1004113|
|000047c0| 36 31 39 34 34 32 00 00 | 04 31 31 30 32 0e 31 30 |619442..|.1102.10|
|000047d0| 30 34 31 32 31 36 38 31 | 32 31 39 00 00 04 31 30 |04121681|219...10|
|000047e0| 39 35 0e 31 30 30 34 31 | 31 33 36 31 39 38 37 37 |95.10041|13619877|
|000047f0| 00 00 04 31 31 30 36 0e | 31 30 30 34 31 32 30 30 |...1106.|10041200|
|00004800| 37 30 31 34 35 00 00 04 | 31 30 38 31 0e 31 30 30 |70145...|1081.100|
|00004810| 34 31 31 33 36 31 39 31 | 36 38 00 00 04 31 31 30 |41136191|68...110|
|00004820| 30 0e 31 30 30 34 31 31 | 33 36 32 30 31 30 31 00 |0.100411|3620101.|
|00004830| 00 04 31 31 30 38 0e 31 | 30 30 34 32 30 33 30 30 |..1108.1|00420300|
|00004840| 39 38 39 38 00 00 04 31 | 31 31 30 0e 31 30 30 34 |9898...1|110.1004|
|00004850| 32 30 33 36 35 33 30 33 | 33 00 00 04 31 31 31 33 |20365303|3...1113|
|00004860| 0e 31 30 30 34 31 31 33 | 36 31 39 37 36 38 00 00 |.1004113|619768..|
|00004870| 04 31 31 30 35 0e 31 30 | 30 34 31 31 32 39 37 37 |.1105.10|04112977|
|00004880| 31 30 37 00 00 04 31 30 | 32 37 0e 31 30 30 34 31 |107...10|27.10041|
|00004890| 31 33 36 31 39 33 33 38 | 00 00 04 31 31 30 31 0e |13619338|...1101.|
|000048a0| 31 30 30 34 31 32 31 35 | 31 33 31 35 32 00 00 04 |10041215|13152...|
|000048b0| 31 30 39 33 0e 31 30 30 | 34 31 31 37 34 39 30 37 |1093.100|41174907|
|000048c0| 31 30 00 00 04 31 30 38 | 30 0e 31 30 30 34 31 31 |10...108|0.100411|
|000048d0| 33 36 31 39 36 35 39 00 | 00 04 31 31 30 34 0e 31 |3619659.|..1104.1|
|000048e0| 30 30 34 32 30 33 36 32 | 33 35 39 36 00 00 04 31 |00420362|3596...1|
|000048f0| 31 31 32 0e 31 30 30 34 | 31 31 33 36 31 39 35 34 |112.1004|11361954|
|00004900| 39 00 00 04 31 31 30 33 | 0e 31 30 30 34 31 31 32 |9...1103|.1004112|
|00004910| 35 37 33 30 34 38 00 00 | 04 31 30 32 34 0e 31 30 |573048..|.1024.10|
|00004920| 30 34 32 30 32 39 35 35 | 33 36 37 00 00 04 31 31 |04202955|367...11|
|00004930| 31 31 0e 31 30 30 34 31 | 31 32 33 36 32 36 39 33 |11.10041|12362693|
|00004940| 00 00 04 31 30 32 32 0e | 31 30 30 34 31 32 32 36 |...1022.|10041226|
|00004950| 33 36 36 36 39 00 00 04 | 31 30 33 30 0e 31 30 30 |36669...|1030.100|
|00004960| 34 31 32 32 36 33 36 36 | 37 30 00 00 04 31 30 33 |41226366|70...103|
|00004970| 31 0e 31 30 30 34 31 32 | 32 36 33 36 36 37 31 00 |1.100412|2636671.|
|00004980| 00 04 31 30 33 32 18 00 | 12 63 52 45 56 47 65 6f |..1032..|.cREVGeo|
|00004990| 6d 65 74 72 79 43 61 63 | 68 65 00 00 00 00 02 06 |metryCac|he......|
|000049a0| 6f 72 64 65 72 00 00 0e | 31 30 30 34 31 31 32 33 |order...|10041123|
|000049b0| 36 32 36 39 33 0a 06 74 | 6f 74 61 6c 00 00 02 32 |62693..t|otal...2|
|000049c0| 37 07 00 00 04 00 07 00 | 00 04 02 07 00 00 04 03 |7.......|........|
|000049d0| 07 00 00 04 38 07 00 00 | 04 58 07 00 00 04 59 04 |....8...|.X....Y.|
|000049e0| 00 00 04 01 00 05 48 65 | 6c 70 00 00 00 09 40 00 |......He|lp....@.|
|000049f0| 00 00 00 80 00 00 00 00 | 00 01 92 01 94 00 00 00 |........|........|
|00004a00| 01 0e 63 52 45 56 4d 69 | 6e 48 65 69 67 68 74 00 |..cREVMi|nHeight.|
|00004a10| 00 03 34 30 34 18 00 0c | 63 52 45 56 47 65 6e 65 |..404...|cREVGene|
|00004a20| 72 61 6c 00 00 00 00 06 | 0a 62 6f 6f 6b 6d 61 72 |ral.....|.bookmar|
|00004a30| 6b 73 00 00 00 0c 68 61 | 6e 64 6c 65 72 4c 69 73 |ks....ha|ndlerLis|
|00004a40| 74 00 00 00 0b 74 65 6d | 70 53 63 72 69 70 74 00 |t....tem|pScript.|
|00004a50| 00 00 0c 70 72 65 76 48 | 61 6e 64 6c 65 72 00 00 |...prevH|andler..|
|00004a60| 00 10 73 63 72 69 70 74 | 53 65 6c 65 63 74 69 6f |..script|Selectio|
|00004a70| 6e 00 00 0b 63 68 61 72 | 20 31 20 74 6f 20 30 07 |n...char| 1 to 0.|
|00004a80| 73 63 72 69 70 74 00 00 | 00 18 00 15 63 52 45 56 |script..|....cREV|
|00004a90| 47 65 6f 6d 65 74 72 79 | 43 61 63 68 65 49 44 73 |Geometry|CacheIDs|
|00004aa0| 00 00 00 00 05 0e 31 30 | 30 34 31 31 33 30 33 36 |......10|04113036|
|00004ab0| 30 32 33 00 00 04 31 30 | 33 37 0e 31 30 30 34 31 |023...10|37.10041|
|00004ac0| 32 30 30 37 30 31 34 35 | 00 00 04 31 30 38 31 0e |20070145|...1081.|
|00004ad0| 31 30 30 35 31 35 34 31 | 38 32 31 38 30 00 00 04 |10051541|82180...|
|00004ae0| 31 31 31 35 0e 31 30 30 | 34 31 31 32 35 37 33 30 |1115.100|41125730|
|00004af0| 34 38 00 00 04 31 30 32 | 34 0e 31 30 30 34 31 31 |48...102|4.100411|
|00004b00| 32 33 36 32 36 39 33 00 | 00 04 31 30 32 32 18 00 |2362693.|..1022..|
|00004b10| 12 63 52 45 56 47 65 6f | 6d 65 74 72 79 43 61 63 |.cREVGeo|metryCac|
|00004b20| 68 65 00 00 00 00 02 06 | 6f 72 64 65 72 00 00 1c |he......|order...|
|00004b30| 31 30 30 34 31 31 32 33 | 36 32 36 39 33 0a 31 30 |10041123|62693.10|
|00004b40| 30 34 31 31 33 30 33 36 | 30 32 33 0a 06 74 6f 74 |04113036|023..tot|
|00004b50| 61 6c 00 00 01 35 07 00 | 00 04 00 07 00 00 04 0d |al...5..|........|
|00004b60| 07 00 00 04 5b 05 00 00 | 04 00 00 05 54 61 62 73 |....[...|....Tabs|
|00004b70| 00 09 00 e9 00 00 00 00 | 00 80 00 ff fa ff d9 01 |........|........|
|00004b80| 9d 01 c1 00 00 00 00 18 | 00 0c 63 52 45 56 47 65 |........|..cREVGe|
|00004b90| 6e 65 72 61 6c 00 00 00 | 00 01 0c 72 65 76 55 6e |neral...|...revUn|
|00004ba0| 69 71 75 65 49 44 00 00 | 0d 31 30 30 34 31 31 32 |iqueID..|.1004112|
|00004bb0| 35 37 33 30 34 38 08 00 | 00 03 fe 00 05 54 61 62 |573048..|.....Tab|
|00004bc0| 73 00 e8 c1 ab 7d 00 11 | 00 10 00 4e 6f 6e 20 6d |s....}..|...Non m|
|00004bd0| 65 6e 75 50 69 63 6b 20 | 70 57 68 69 63 68 0a 20 |enuPick |pWhich. |
|00004be0| 20 6c 6f 63 6b 20 73 63 | 72 65 65 6e 0a 20 20 67 | lock sc|reen.  g|
|00004bf0| 6f 20 63 64 20 70 57 68 | 69 63 68 0a 20 20 75 6e |o cd pWh|ich.  un|
|00004c00| 6c 6f 63 6b 20 73 63 72 | 65 65 6e 0a 65 6e 64 20 |lock scr|een.end |
|00004c10| 6d 65 6e 75 50 69 63 6b | 0a 00 00 00 00 00 80 00 |menuPick|........|
|00004c20| ff fe 00 06 01 95 00 ca | 00 00 00 00 00 00 00 16 |........|........|
|00004c30| 54 65 78 74 20 44 61 74 | 61 0a 42 69 6e 61 72 79 |Text Dat|a.Binary|
|00004c40| 20 44 61 74 61 00 01 01 | 00 01 00 00 00 00 02 00 | Data...|........|
|00004c50| 18 00 0d 63 52 45 56 47 | 65 6f 6d 65 74 72 79 00 |...cREVG|eometry.|
|00004c60| 00 00 00 17 1d 4d 61 73 | 74 65 72 2c 73 63 61 6c |.....Mas|ter,scal|
|00004c70| 65 42 6f 74 74 6f 6d 4f | 62 6a 65 63 74 53 69 64 |eBottomO|bjectSid|
|00004c80| 65 00 00 06 42 6f 74 74 | 6f 6d 07 4d 61 73 74 65 |e...Bott|om.Maste|
|00004c90| 72 00 00 04 74 72 75 65 | 1a 4d 61 73 74 65 72 2c |r...true|.Master,|
|00004ca0| 73 63 61 6c 65 4c 65 66 | 74 4f 62 6a 65 63 74 52 |scaleLef|tObjectR|
|00004cb0| 65 66 00 00 00 19 4d 61 | 73 74 65 72 2c 73 63 61 |ef....Ma|ster,sca|
|00004cc0| 6c 65 74 6f 70 4f 62 6a | 65 63 74 52 65 66 00 00 |letopObj|ectRef..|
|00004cd0| 00 1c 4d 61 73 74 65 72 | 2c 73 63 61 6c 65 42 6f |..Master|,scaleBo|
|00004ce0| 74 74 6f 6d 4f 62 6a 65 | 63 74 52 65 66 00 00 04 |ttomObje|ctRef...|
|00004cf0| 43 61 72 64 1b 4d 61 73 | 74 65 72 2c 73 63 61 6c |Card.Mas|ter,scal|
|00004d00| 65 42 6f 74 74 6f 6d 41 | 62 73 6f 6c 75 74 65 00 |eBottomA|bsolute.|
|00004d10| 00 04 74 72 75 65 13 4d | 61 73 74 65 72 2c 73 63 |..true.M|aster,sc|
|00004d20| 61 6c 65 42 6f 74 74 6f | 6d 00 00 04 74 72 75 65 |aleBotto|m...true|
|00004d30| 1b 4d 61 73 74 65 72 2c | 73 63 61 6c 65 4c 65 66 |.Master,|scaleLef|
|00004d40| 74 4f 62 6a 65 63 74 53 | 69 64 65 00 00 06 63 65 |tObjectS|ide...ce|
|00004d50| 6e 74 65 72 1a 4d 61 73 | 74 65 72 2c 73 63 61 6c |nter.Mas|ter,scal|
|00004d60| 65 54 6f 70 4f 62 6a 65 | 63 74 53 69 64 65 00 00 |eTopObje|ctSide..|
|00004d70| 06 63 65 6e 74 65 72 14 | 4d 61 73 74 65 72 2c 65 |.center.|Master,e|
|00004d80| 78 70 65 63 74 65 64 52 | 65 63 74 00 00 0e 2d 32 |xpectedR|ect...-2|
|00004d90| 2c 31 33 39 2c 34 30 33 | 2c 35 31 30 1b 4d 61 73 |,139,403|,510.Mas|
|00004da0| 74 65 72 2c 73 63 61 6c | 65 62 6f 74 74 6f 6d 44 |ter,scal|ebottomD|
|00004db0| 69 73 74 61 6e 63 65 00 | 00 01 32 1a 4d 61 73 74 |istance.|..2.Mast|
|00004dc0| 65 72 2c 73 63 61 6c 65 | 52 69 67 68 74 41 62 73 |er,scale|RightAbs|
|00004dd0| 6f 6c 75 74 65 00 00 05 | 66 61 6c 73 65 12 4d 61 |olute...|false.Ma|
|00004de0| 73 74 65 72 2c 73 63 61 | 6c 65 52 69 67 68 74 00 |ster,sca|leRight.|
|00004df0| 00 05 66 61 6c 73 65 1a | 4d 61 73 74 65 72 2c 73 |..false.|Master,s|
|00004e00| 63 61 6c 65 72 69 67 68 | 74 44 69 73 74 61 6e 63 |calerigh|tDistanc|
|00004e10| 65 00 00 01 30 18 4d 61 | 73 74 65 72 2c 73 63 61 |e...0.Ma|ster,sca|
|00004e20| 6c 65 54 6f 70 41 62 73 | 6f 6c 75 74 65 00 00 05 |leTopAbs|olute...|
|00004e30| 66 61 6c 73 65 1b 4d 61 | 73 74 65 72 2c 73 63 61 |false.Ma|ster,sca|
|00004e40| 6c 65 52 69 67 68 74 4f | 62 6a 65 63 74 52 65 66 |leRightO|bjectRef|
|00004e50| 00 00 00 1c 4d 61 73 74 | 65 72 2c 73 63 61 6c 65 |....Mast|er,scale|
|00004e60| 52 69 67 68 74 4f 62 6a | 65 63 74 53 69 64 65 00 |RightObj|ectSide.|
|00004e70| 00 06 63 65 6e 74 65 72 | 19 4d 61 73 74 65 72 2c |..center|.Master,|
|00004e80| 73 63 61 6c 65 4c 65 66 | 74 41 62 73 6f 6c 75 74 |scaleLef|tAbsolut|
|00004e90| 65 00 00 05 66 61 6c 73 | 65 10 4d 61 73 74 65 72 |e...fals|e.Master|
|00004ea0| 2c 73 63 61 6c 65 54 6f | 70 00 00 05 66 61 6c 73 |,scaleTo|p...fals|
|00004eb0| 65 11 4d 61 73 74 65 72 | 2c 73 63 61 6c 65 4c 65 |e.Master|,scaleLe|
|00004ec0| 66 74 00 00 05 66 61 6c | 73 65 13 4d 61 73 74 65 |ft...fal|se.Maste|
|00004ed0| 72 2c 63 61 72 64 52 61 | 6e 6b 69 6e 67 00 00 01 |r,cardRa|nking...|
|00004ee0| 31 19 4d 61 73 74 65 72 | 2c 73 63 61 6c 65 6c 65 |1.Master|,scalele|
|00004ef0| 66 74 44 69 73 74 61 6e | 63 65 00 00 01 30 18 4d |ftDistan|ce...0.M|
|00004f00| 61 73 74 65 72 2c 73 63 | 61 6c 65 74 6f 70 44 69 |aster,sc|aletopDi|
|00004f10| 73 74 61 6e 63 65 00 00 | 01 30 18 00 0c 63 52 45 |stance..|.0...cRE|
|00004f20| 56 47 65 6e 65 72 61 6c | 00 00 00 00 08 0f 73 63 |VGeneral|......sc|
|00004f30| 72 69 70 74 43 68 65 63 | 6b 73 75 6d 00 00 10 3d |riptChec|ksum...=|
|00004f40| 86 16 bf b7 f8 d0 a5 44 | c4 7c 8f 3d 98 db a6 0a |.......D|.|.=....|
|00004f50| 62 6f 6f 6b 6d 61 72 6b | 73 00 00 00 0c 72 65 76 |bookmark|s....rev|
|00004f60| 55 6e 69 71 75 65 49 44 | 00 00 0d 31 30 30 34 31 |UniqueID|...10041|
|00004f70| 31 32 33 36 32 36 39 33 | 0c 68 61 6e 64 6c 65 72 |12362693|.handler|
|00004f80| 4c 69 73 74 00 00 08 6d | 65 6e 75 50 69 63 6b 10 |List...m|enuPick.|
|00004f90| 73 63 72 69 70 74 53 65 | 6c 65 63 74 69 6f 6e 00 |scriptSe|lection.|
|00004fa0| 00 0d 63 68 61 72 20 36 | 34 20 74 6f 20 36 33 0c |..char 6|4 to 63.|
|00004fb0| 70 72 65 76 48 61 6e 64 | 6c 65 72 00 00 08 6d 65 |prevHand|ler...me|
|00004fc0| 6e 75 50 69 63 6b 0b 74 | 65 6d 70 53 63 72 69 70 |nuPick.t|empScrip|
|00004fd0| 74 00 00 00 07 73 63 72 | 69 70 74 00 00 6f 3c 70 |t....scr|ipt..o<p|
|00004fe0| 3e 6f 6e 20 6d 65 6e 75 | 50 69 63 6b 20 70 57 68 |>on menu|Pick pWh|
|00004ff0| 69 63 68 3c 2f 70 3e 0a | 3c 70 3e 20 20 6c 6f 63 |ich</p>.|<p>  loc|
|00005000| 6b 20 73 63 72 65 65 6e | 3c 2f 70 3e 0a 3c 70 3e |k screen|</p>.<p>|
|00005010| 20 20 67 6f 20 63 64 20 | 70 57 68 69 63 68 3c 2f |  go cd |pWhich</|
|00005020| 70 3e 0a 3c 70 3e 20 20 | 75 6e 6c 6f 63 6b 20 73 |p>.<p>  |unlock s|
|00005030| 63 72 65 65 6e 3c 2f 70 | 3e 0a 3c 70 3e 65 6e 64 |creen</p|>.<p>end|
|00005040| 20 6d 65 6e 75 50 69 63 | 6b 3c 2f 70 3e 09 00 00 | menuPic|k</p>...|
|00005050| 00 00 00 08 00 00 04 39 | 00 09 50 72 6f 67 72 65 |.......9|..Progre|
|00005060| 73 73 00 ea 43 0b 40 00 | 00 00 00 80 00 01 79 ff |ss..C.@.|......y.|
|00005070| dd 00 14 00 14 00 00 00 | 02 0e 63 4f 66 66 53 63 |........|..cOffSc|
|00005080| 72 65 65 6e 4c 6f 63 00 | 00 07 33 38 37 2c 2d 32 |reenLoc.|..387,-2|
|00005090| 35 0d 63 4f 6e 53 63 72 | 65 65 6e 4c 6f 63 00 00 |5.cOnScr|eenLoc..|
|000050a0| 06 33 38 37 2c 31 35 00 | 00 00 00 00 00 00 00 00 |.387,15.|........|
|000050b0| 00 00 00 00 03 34 99 00 | 00 00 00 00 00 01 00 00 |.....4..|........|
|000050c0| 00 00 00 00 00 18 00 0c | 63 52 45 56 47 65 6e 65 |........|cREVGene|
|000050d0| 72 61 6c 00 00 00 00 01 | 0c 72 65 76 55 6e 69 71 |ral.....|.revUniq|
|000050e0| 75 65 49 44 00 00 0d 31 | 30 30 34 31 32 30 30 37 |ueID...1|00412007|
|000050f0| 30 31 34 35 09 00 00 00 | 00 00 06 0a 00 00 04 02 |0145....|........|
|00005100| 00 00 18 14 09 10 00 a5 | 6f 6e 20 6d 6f 75 73 65 |........|on mouse|
|00005110| 55 70 0a 20 20 69 66 20 | 74 68 65 20 63 6c 69 63 |Up.  if |the clic|
|00005120| 6b 54 65 78 74 20 69 73 | 20 22 68 65 6c 70 22 20 |kText is| "help" |
|00005130| 74 68 65 6e 0a 20 20 20 | 20 6c 6f 63 6b 20 73 63 |then.   | lock sc|
|00005140| 72 65 65 6e 0a 20 20 20 | 20 67 6f 20 63 64 20 22 |reen.   | go cd "|
|00005150| 68 65 6c 70 22 0a 20 20 | 20 20 73 65 74 20 74 68 |help".  |  set th|
|00005160| 65 20 6d 65 6e 75 48 69 | 73 74 6f 72 79 20 6f 66 |e menuHi|story of|
|00005170| 20 62 74 6e 20 22 74 61 | 62 73 22 20 74 6f 20 33 | btn "ta|bs" to 3|
|00005180| 0a 20 20 20 20 75 6e 6c | 6f 63 6b 20 73 63 72 65 |.    unl|ock scre|
|00005190| 65 6e 20 20 20 20 0a 20 | 20 65 6e 64 20 69 66 0a |en    . | end if.|
|000051a0| 65 6e 64 20 6d 6f 75 73 | 65 55 70 0a 00 00 00 00 |end mous|eUp.....|
|000051b0| 00 80 00 00 02 00 1e 01 | 90 00 30 00 00 00 00 00 |........|..0.....|
|000051c0| 08 00 08 00 08 00 08 00 | 00 18 00 0c 63 52 45 56 |........|....cREV|
|000051d0| 47 65 6e 65 72 61 6c 00 | 00 00 00 08 0f 73 63 72 |General.|.....scr|
|000051e0| 69 70 74 43 68 65 63 6b | 73 75 6d 00 00 10 77 89 |iptCheck|sum...w.|
|000051f0| f7 9d 14 8f b6 5a d8 46 | 94 55 e0 25 95 b6 0c 72 |.....Z.F|.U.%...r|
|00005200| 65 76 55 6e 69 71 75 65 | 49 44 00 00 0d 31 30 30 |evUnique|ID...100|
|00005210| 34 31 31 32 39 37 36 39 | 31 31 0a 62 6f 6f 6b 6d |41129769|11.bookm|
|00005220| 61 72 6b 73 00 00 00 0c | 68 61 6e 64 6c 65 72 4c |arks....|handlerL|
|00005230| 69 73 74 00 00 07 6d 6f | 75 73 65 55 70 0b 74 65 |ist...mo|useUp.te|
|00005240| 6d 70 53 63 72 69 70 74 | 00 00 00 0c 70 72 65 76 |mpScript|....prev|
|00005250| 48 61 6e 64 6c 65 72 00 | 00 00 10 73 63 72 69 70 |Handler.|...scrip|
|00005260| 74 53 65 6c 65 63 74 69 | 6f 6e 00 00 0f 63 68 61 |tSelecti|on...cha|
|00005270| 72 20 31 32 31 20 74 6f | 20 31 32 30 07 73 63 72 |r 121 to| 120.scr|
|00005280| 69 70 74 00 00 db 3c 70 | 3e 6f 6e 20 6d 6f 75 73 |ipt...<p|>on mous|
|00005290| 65 55 70 3c 2f 70 3e 0a | 3c 70 3e 20 20 69 66 20 |eUp</p>.|<p>  if |
|000052a0| 74 68 65 20 63 6c 69 63 | 6b 54 65 78 74 20 69 73 |the clic|kText is|
|000052b0| 20 22 68 65 6c 70 22 20 | 74 68 65 6e 3c 2f 70 3e | "help" |then</p>|
|000052c0| 0a 3c 70 3e 20 20 20 20 | 6c 6f 63 6b 20 73 63 72 |.<p>    |lock scr|
|000052d0| 65 65 6e 3c 2f 70 3e 0a | 3c 70 3e 20 20 20 20 67 |een</p>.|<p>    g|
|000052e0| 6f 20 63 64 20 22 68 65 | 6c 70 22 3c 2f 70 3e 0a |o cd "he|lp"</p>.|
|000052f0| 3c 70 3e 20 20 20 20 73 | 65 74 20 74 68 65 20 6d |<p>    s|et the m|
|00005300| 65 6e 75 48 69 73 74 6f | 72 79 20 6f 66 20 62 74 |enuHisto|ry of bt|
|00005310| 6e 20 22 74 61 62 73 22 | 20 74 6f 20 33 3c 2f 70 |n "tabs"| to 3</p|
|00005320| 3e 0a 3c 70 3e 20 20 20 | 20 75 6e 6c 6f 63 6b 20 |>.<p>   | unlock |
|00005330| 73 63 72 65 65 6e 20 20 | 20 20 3c 2f 70 3e 0a 3c |screen  |  </p>.<|
|00005340| 70 3e 20 20 65 6e 64 20 | 69 66 3c 2f 70 3e 0a 3c |p>  end |if</p>.<|
|00005350| 70 3e 65 6e 64 20 6d 6f | 75 73 65 55 70 3c 2f 70 |p>end mo|useUp</p|
|00005360| 3e 0b 00 00 00 00 0c 00 | 94 54 68 65 20 62 65 6c |>.......|.The bel|
|00005370| 6f 77 20 65 78 61 6d 70 | 6c 65 20 73 68 6f 77 73 |ow examp|le shows|
|00005380| 20 68 6f 77 20 52 65 76 | 6f 6c 75 74 69 6f 6e 20 | how Rev|olution |
|00005390| 63 61 6e 20 62 65 20 75 | 73 65 64 20 74 6f 20 67 |can be u|sed to g|
|000053a0| 65 74 20 61 6e 64 20 73 | 65 74 20 62 69 6e 61 72 |et and s|et binar|
|000053b0| 79 20 64 61 74 61 20 28 | 69 6e 20 74 68 69 73 20 |y data (|in this |
|000053c0| 63 61 73 65 20 61 6e 20 | 69 6d 61 67 65 29 20 69 |case an |image) i|
|000053d0| 6e 20 61 20 64 61 74 61 | 62 61 73 65 2e 20 53 65 |n a data|base. Se|
|000053e0| 65 20 48 65 6c 70 20 66 | 6f 72 20 6d 6f 72 65 20 |e Help f|or more |
|000053f0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 2e 00 0d 00 00 |informat|ion.....|
|00005400| 00 00 00 00 00 79 0d 00 | 00 00 08 00 12 00 79 00 |.....y..|......y.|
|00005410| 04 0d 00 00 00 08 00 13 | 00 7d 00 16 08 00 00 04 |........|.}......|
|00005420| 03 00 0b 43 6f 6e 6e 65 | 63 74 2e 2e 2e 00 e8 65 |...Conne|ct.....e|
|00005430| ab 70 03 c1 6f 6e 20 6d | 6f 75 73 65 55 70 0a 20 |.p..on m|ouseUp. |
|00005440| 20 67 6c 6f 62 61 6c 20 | 69 6d 61 67 65 64 62 0a | global |imagedb.|
|00005450| 20 20 69 66 20 74 68 65 | 20 6c 61 62 65 6c 20 6f |  if the| label o|
|00005460| 66 20 6d 65 20 69 73 20 | 22 43 6f 6e 6e 65 63 74 |f me is |"Connect|
|00005470| 2e 2e 2e 22 20 74 68 65 | 6e 0a 20 20 20 20 6c 6f |..." the|n.    lo|
|00005480| 63 61 6c 20 63 69 6e 66 | 6f 2c 64 62 72 65 73 75 |cal cinf|o,dbresu|
|00005490| 6c 74 0a 20 20 20 20 70 | 75 74 20 22 64 62 74 79 |lt.    p|ut "dbty|
|000054a0| 70 65 22 2c 6c 61 62 65 | 6c 20 6f 66 20 62 75 74 |pe",labe|l of but|
|000054b0| 74 6f 6e 20 22 44 42 54 | 59 50 45 22 26 63 72 26 |ton "DBT|YPE"&cr&|
|000054c0| 5c 0a 20 20 20 20 20 20 | 20 20 22 64 62 68 6f 73 |\.      |  "dbhos|
|000054d0| 74 22 2c 66 69 65 6c 64 | 20 22 44 42 48 4f 53 54 |t",field| "DBHOST|
|000054e0| 22 26 63 72 26 5c 0a 20 | 20 20 20 20 20 20 20 22 |"&cr&\. |       "|
|000054f0| 64 62 64 61 74 61 62 61 | 73 65 22 2c 66 69 65 6c |dbdataba|se",fiel|
|00005500| 64 20 22 44 42 44 41 54 | 41 42 41 53 45 22 26 63 |d "DBDAT|ABASE"&c|
|00005510| 72 26 5c 0a 20 20 20 20 | 20 20 20 20 22 64 62 75 |r&\.    |    "dbu|
|00005520| 73 65 72 22 2c 66 69 65 | 6c 64 20 22 44 42 55 53 |ser",fie|ld "DBUS|
|00005530| 45 52 22 26 63 72 26 5c | 0a 20 20 20 20 20 20 20 |ER"&cr&\|.       |
|00005540| 20 22 64 62 70 61 73 73 | 77 6f 72 64 22 2c 66 69 | "dbpass|word",fi|
|00005550| 65 6c 64 20 22 44 42 50 | 41 53 53 57 4f 52 44 22 |eld "DBP|ASSWORD"|
|00005560| 20 69 6e 74 6f 20 63 69 | 6e 66 6f 0a 20 20 0a 20 | into ci|nfo.  . |
|00005570| 20 20 20 73 70 6c 69 74 | 20 63 69 6e 66 6f 20 62 |   split| cinfo b|
|00005580| 79 20 72 65 74 75 72 6e | 20 61 6e 64 20 63 6f 6d |y return| and com|
|00005590| 6d 61 0a 20 20 20 20 70 | 75 74 20 72 65 76 64 62 |ma.    p|ut revdb|
|000055a0| 5f 63 6f 6e 6e 65 63 74 | 28 63 69 6e 66 6f 5b 22 |_connect|(cinfo["|
|000055b0| 64 62 74 79 70 65 22 5d | 2c 63 69 6e 66 6f 5b 22 |dbtype"]|,cinfo["|
|000055c0| 64 62 68 6f 73 74 22 5d | 2c 63 69 6e 66 6f 5b 22 |dbhost"]|,cinfo["|
|000055d0| 64 62 64 61 74 61 62 61 | 73 65 22 5d 2c 5c 0a 20 |dbdataba|se"],\. |
|000055e0| 20 20 20 20 20 20 20 63 | 69 6e 66 6f 5b 22 64 62 |       c|info["db|
|000055f0| 75 73 65 72 22 5d 2c 63 | 69 6e 66 6f 5b 22 64 62 |user"],c|info["db|
|00005600| 70 61 73 73 77 6f 72 64 | 22 5d 29 20 69 6e 74 6f |password|"]) into|
|00005610| 20 64 62 72 65 73 75 6c | 74 0a 20 20 20 20 69 66 | dbresul|t.    if|
|00005620| 20 64 62 72 65 73 75 6c | 74 20 69 73 20 61 20 6e | dbresul|t is a n|
|00005630| 75 6d 62 65 72 20 74 68 | 65 6e 0a 20 20 20 20 20 |umber th|en.     |
|00005640| 20 70 75 74 20 64 62 72 | 65 73 75 6c 74 20 69 6e | put dbr|esult in|
|00005650| 74 6f 20 69 6d 61 67 65 | 64 62 0a 20 20 20 20 20 |to image|db.     |
|00005660| 20 6c 6f 63 6b 20 73 63 | 72 65 65 6e 0a 20 20 20 | lock sc|reen.   |
|00005670| 20 20 20 73 65 74 20 74 | 68 65 20 6c 61 62 65 6c |   set t|he label|
|00005680| 20 6f 66 20 6d 65 20 74 | 6f 20 22 44 69 73 63 6f | of me t|o "Disco|
|00005690| 6e 6e 65 63 74 22 0a 20 | 20 20 20 20 20 65 6e 61 |nnect". |     ena|
|000056a0| 62 6c 65 20 67 72 70 20 | 22 41 64 64 20 52 65 63 |ble grp |"Add Rec|
|000056b0| 6f 72 64 20 74 6f 20 44 | 61 74 61 62 61 73 65 22 |ord to D|atabase"|
|000056c0| 0a 20 20 20 20 20 20 65 | 6e 61 62 6c 65 20 67 72 |.      e|nable gr|
|000056d0| 70 20 22 47 65 74 20 52 | 65 63 6f 72 64 20 66 72 |p "Get R|ecord fr|
|000056e0| 6f 6d 20 44 61 74 61 62 | 61 73 65 22 0a 20 20 20 |om Datab|ase".   |
|000056f0| 20 20 20 75 6e 6c 6f 63 | 6b 20 73 63 72 65 65 6e |   unloc|k screen|
|00005700| 0a 20 20 20 20 65 6c 73 | 65 20 61 6e 73 77 65 72 |.    els|e answer|
|00005710| 20 64 62 72 65 73 75 6c | 74 0a 20 20 65 6c 73 65 | dbresul|t.  else|
|00005720| 0a 20 20 20 20 67 65 74 | 20 72 65 76 64 62 5f 64 |.    get| revdb_d|
|00005730| 69 73 63 6f 6e 6e 65 63 | 74 28 69 6d 61 67 65 64 |isconnec|t(imaged|
|00005740| 62 29 0a 20 20 20 20 6c | 6f 63 6b 20 73 63 72 65 |b).    l|ock scre|
|00005750| 65 6e 0a 20 20 20 20 73 | 65 74 20 74 68 65 20 6c |en.    s|et the l|
|00005760| 61 62 65 6c 20 6f 66 20 | 6d 65 20 74 6f 20 22 43 |abel of |me to "C|
|00005770| 6f 6e 6e 65 63 74 2e 2e | 2e 22 0a 20 20 20 20 65 |onnect..|.".    e|
|00005780| 6e 61 62 6c 65 20 67 72 | 70 20 22 41 64 64 20 52 |nable gr|p "Add R|
|00005790| 65 63 6f 72 64 20 74 6f | 20 44 61 74 61 62 61 73 |ecord to| Databas|
|000057a0| 65 22 0a 20 20 20 20 65 | 6e 61 62 6c 65 20 67 72 |e".    e|nable gr|
|000057b0| 70 20 22 47 65 74 20 52 | 65 63 6f 72 64 20 66 72 |p "Get R|ecord fr|
|000057c0| 6f 6d 20 44 61 74 61 62 | 61 73 65 22 0a 20 20 20 |om Datab|ase".   |
|000057d0| 20 75 6e 6c 6f 63 6b 20 | 73 63 72 65 65 6e 0a 20 | unlock |screen. |
|000057e0| 20 65 6e 64 20 69 66 0a | 65 6e 64 20 6d 6f 75 73 | end if.|end mous|
|000057f0| 65 55 70 0a 00 00 00 00 | 00 80 00 00 f1 00 7f 00 |eUp.....|........|
|00005800| 76 00 14 00 00 00 00 00 | 0b 43 6f 6e 6e 65 63 74 |v.......|.Connect|
|00005810| 2e 2e 2e 00 00 00 01 00 | 00 00 00 00 00 00 18 00 |........|........|
|00005820| 0c 63 52 45 56 47 65 6e | 65 72 61 6c 00 00 00 00 |.cREVGen|eral....|
|00005830| 08 0f 73 63 72 69 70 74 | 43 68 65 63 6b 73 75 6d |..script|Checksum|
|00005840| 00 00 10 e9 d0 c6 bc 22 | c3 28 b2 cb 00 44 ab dd |......."|.(...D..|
|00005850| 26 52 22 0c 72 65 76 55 | 6e 69 71 75 65 49 44 00 |&R".revU|niqueID.|
|00005860| 00 0d 31 30 30 34 31 31 | 32 39 37 37 31 30 37 0a |..100411|2977107.|
|00005870| 62 6f 6f 6b 6d 61 72 6b | 73 00 00 00 0c 68 61 6e |bookmark|s....han|
|00005880| 64 6c 65 72 4c 69 73 74 | 00 00 07 6d 6f 75 73 65 |dlerList|...mouse|
|00005890| 55 70 0b 74 65 6d 70 53 | 63 72 69 70 74 00 00 00 |Up.tempS|cript...|
|000058a0| 0c 70 72 65 76 48 61 6e | 64 6c 65 72 00 00 07 6d |.prevHan|dler...m|
|000058b0| 6f 75 73 65 55 70 10 73 | 63 72 69 70 74 53 65 6c |ouseUp.s|criptSel|
|000058c0| 65 63 74 69 6f 6e 00 00 | 0f 63 68 61 72 20 39 36 |ection..|.char 96|
|000058d0| 32 20 74 6f 20 39 36 31 | 07 73 63 72 69 70 74 00 |2 to 961|.script.|
|000058e0| 04 ba 3c 70 3e 6f 6e 20 | 6d 6f 75 73 65 55 70 3c |..<p>on |mouseUp<|
|000058f0| 2f 70 3e 0a 3c 70 3e 20 | 20 67 6c 6f 62 61 6c 20 |/p>.<p> | global |
|00005900| 69 6d 61 67 65 64 62 3c | 2f 70 3e 0a 3c 70 3e 20 |imagedb<|/p>.<p> |
|00005910| 20 69 66 20 74 68 65 20 | 6c 61 62 65 6c 20 6f 66 | if the |label of|
|00005920| 20 6d 65 20 69 73 20 22 | 43 6f 6e 6e 65 63 74 2e | me is "|Connect.|
|00005930| 2e 2e 22 20 74 68 65 6e | 3c 2f 70 3e 0a 3c 70 3e |.." then|</p>.<p>|
|00005940| 20 20 20 20 6c 6f 63 61 | 6c 20 63 69 6e 66 6f 2c |    loca|l cinfo,|
|00005950| 64 62 72 65 73 75 6c 74 | 3c 2f 70 3e 0a 3c 70 3e |dbresult|</p>.<p>|
|00005960| 20 20 20 20 70 75 74 20 | 22 64 62 74 79 70 65 22 |    put |"dbtype"|
|00005970| 2c 6c 61 62 65 6c 20 6f | 66 20 62 75 74 74 6f 6e |,label o|f button|
|00005980| 20 22 44 42 54 59 50 45 | 22 26 61 6d 70 3b 63 72 | "DBTYPE|"&amp;cr|
|00005990| 26 61 6d 70 3b 5c 3c 2f | 70 3e 0a 3c 70 3e 20 20 |&amp;\</|p>.<p>  |
|000059a0| 20 20 20 20 20 20 22 64 | 62 68 6f 73 74 22 2c 66 |      "d|bhost",f|
|000059b0| 69 65 6c 64 20 22 44 42 | 48 4f 53 54 22 26 61 6d |ield "DB|HOST"&am|
|000059c0| 70 3b 63 72 26 61 6d 70 | 3b 5c 3c 2f 70 3e 0a 3c |p;cr&amp|;\</p>.<|
|000059d0| 70 3e 20 20 20 20 20 20 | 20 20 22 64 62 64 61 74 |p>      |  "dbdat|
|000059e0| 61 62 61 73 65 22 2c 66 | 69 65 6c 64 20 22 44 42 |abase",f|ield "DB|
|000059f0| 44 41 54 41 42 41 53 45 | 22 26 61 6d 70 3b 63 72 |DATABASE|"&amp;cr|
|00005a00| 26 61 6d 70 3b 5c 3c 2f | 70 3e 0a 3c 70 3e 20 20 |&amp;\</|p>.<p>  |
|00005a10| 20 20 20 20 20 20 22 64 | 62 75 73 65 72 22 2c 66 |      "d|buser",f|
|00005a20| 69 65 6c 64 20 22 44 42 | 55 53 45 52 22 26 61 6d |ield "DB|USER"&am|
|00005a30| 70 3b 63 72 26 61 6d 70 | 3b 5c 3c 2f 70 3e 0a 3c |p;cr&amp|;\</p>.<|
|00005a40| 70 3e 20 20 20 20 20 20 | 20 20 22 64 62 70 61 73 |p>      |  "dbpas|
|00005a50| 73 77 6f 72 64 22 2c 66 | 69 65 6c 64 20 22 44 42 |sword",f|ield "DB|
|00005a60| 50 41 53 53 57 4f 52 44 | 22 20 69 6e 74 6f 20 63 |PASSWORD|" into c|
|00005a70| 69 6e 66 6f 3c 2f 70 3e | 0a 3c 70 3e 20 20 20 3c |info</p>|.<p>   <|
|00005a80| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 73 70 6c 69 74 |/p>.<p> |   split|
|00005a90| 20 63 69 6e 66 6f 20 62 | 79 20 72 65 74 75 72 6e | cinfo b|y return|
|00005aa0| 20 61 6e 64 20 63 6f 6d | 6d 61 3c 2f 70 3e 0a 3c | and com|ma</p>.<|
|00005ab0| 70 3e 20 20 20 20 70 75 | 74 20 72 65 76 64 62 5f |p>    pu|t revdb_|
|00005ac0| 63 6f 6e 6e 65 63 74 28 | 63 69 6e 66 6f 5b 22 64 |connect(|cinfo["d|
|00005ad0| 62 74 79 70 65 22 5d 2c | 63 69 6e 66 6f 5b 22 64 |btype"],|cinfo["d|
|00005ae0| 62 68 6f 73 74 22 5d 2c | 63 69 6e 66 6f 5b 22 64 |bhost"],|cinfo["d|
|00005af0| 62 64 61 74 61 62 61 73 | 65 22 5d 2c 5c 3c 2f 70 |bdatabas|e"],\</p|
|00005b00| 3e 0a 3c 70 3e 20 20 20 | 20 20 20 20 20 63 69 6e |>.<p>   |     cin|
|00005b10| 66 6f 5b 22 64 62 75 73 | 65 72 22 5d 2c 63 69 6e |fo["dbus|er"],cin|
|00005b20| 66 6f 5b 22 64 62 70 61 | 73 73 77 6f 72 64 22 5d |fo["dbpa|ssword"]|
|00005b30| 29 20 69 6e 74 6f 20 64 | 62 72 65 73 75 6c 74 3c |) into d|bresult<|
|00005b40| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 69 66 20 64 62 |/p>.<p> |   if db|
|00005b50| 72 65 73 75 6c 74 20 69 | 73 20 61 20 6e 75 6d 62 |result i|s a numb|
|00005b60| 65 72 20 74 68 65 6e 3c | 2f 70 3e 0a 3c 70 3e 20 |er then<|/p>.<p> |
|00005b70| 20 20 20 20 20 70 75 74 | 20 64 62 72 65 73 75 6c |     put| dbresul|
|00005b80| 74 20 69 6e 74 6f 20 69 | 6d 61 67 65 64 62 3c 2f |t into i|magedb</|
|00005b90| 70 3e 0a 3c 70 3e 20 20 | 20 20 20 20 6c 6f 63 6b |p>.<p>  |    lock|
|00005ba0| 20 73 63 72 65 65 6e 3c | 2f 70 3e 0a 3c 70 3e 20 | screen<|/p>.<p> |
|00005bb0| 20 20 20 20 20 73 65 74 | 20 74 68 65 20 6c 61 62 |     set| the lab|
|00005bc0| 65 6c 20 6f 66 20 6d 65 | 20 74 6f 20 22 44 69 73 |el of me| to "Dis|
|00005bd0| 63 6f 6e 6e 65 63 74 22 | 3c 2f 70 3e 0a 3c 70 3e |connect"|</p>.<p>|
|00005be0| 20 20 20 20 20 20 65 6e | 61 62 6c 65 20 67 72 70 |      en|able grp|
|00005bf0| 20 22 41 64 64 20 52 65 | 63 6f 72 64 20 74 6f 20 | "Add Re|cord to |
|00005c00| 44 61 74 61 62 61 73 65 | 22 3c 2f 70 3e 0a 3c 70 |Database|"</p>.<p|
|00005c10| 3e 20 20 20 20 20 20 65 | 6e 61 62 6c 65 20 67 72 |>      e|nable gr|
|00005c20| 70 20 22 47 65 74 20 52 | 65 63 6f 72 64 20 66 72 |p "Get R|ecord fr|
|00005c30| 6f 6d 20 44 61 74 61 62 | 61 73 65 22 3c 2f 70 3e |om Datab|ase"</p>|
|00005c40| 0a 3c 70 3e 20 20 20 20 | 20 20 75 6e 6c 6f 63 6b |.<p>    |  unlock|
|00005c50| 20 73 63 72 65 65 6e 3c | 2f 70 3e 0a 3c 70 3e 20 | screen<|/p>.<p> |
|00005c60| 20 20 20 65 6c 73 65 20 | 61 6e 73 77 65 72 20 64 |   else |answer d|
|00005c70| 62 72 65 73 75 6c 74 3c | 2f 70 3e 0a 3c 70 3e 20 |bresult<|/p>.<p> |
|00005c80| 20 65 6c 73 65 3c 2f 70 | 3e 0a 3c 70 3e 20 20 20 | else</p|>.<p>   |
|00005c90| 20 67 65 74 20 72 65 76 | 64 62 5f 64 69 73 63 6f | get rev|db_disco|
|00005ca0| 6e 6e 65 63 74 28 69 6d | 61 67 65 64 62 29 3c 2f |nnect(im|agedb)</|
|00005cb0| 70 3e 0a 3c 70 3e 20 20 | 20 20 6c 6f 63 6b 20 73 |p>.<p>  |  lock s|
|00005cc0| 63 72 65 65 6e 3c 2f 70 | 3e 0a 3c 70 3e 20 20 20 |creen</p|>.<p>   |
|00005cd0| 20 73 65 74 20 74 68 65 | 20 6c 61 62 65 6c 20 6f | set the| label o|
|00005ce0| 66 20 6d 65 20 74 6f 20 | 22 43 6f 6e 6e 65 63 74 |f me to |"Connect|
|00005cf0| 2e 2e 2e 22 3c 2f 70 3e | 0a 3c 70 3e 20 20 20 20 |..."</p>|.<p>    |
|00005d00| 65 6e 61 62 6c 65 20 67 | 72 70 20 22 41 64 64 20 |enable g|rp "Add |
|00005d10| 52 65 63 6f 72 64 20 74 | 6f 20 44 61 74 61 62 61 |Record t|o Databa|
|00005d20| 73 65 22 3c 2f 70 3e 0a | 3c 70 3e 20 20 20 20 65 |se"</p>.|<p>    e|
|00005d30| 6e 61 62 6c 65 20 67 72 | 70 20 22 47 65 74 20 52 |nable gr|p "Get R|
|00005d40| 65 63 6f 72 64 20 66 72 | 6f 6d 20 44 61 74 61 62 |ecord fr|om Datab|
|00005d50| 61 73 65 22 3c 2f 70 3e | 0a 3c 70 3e 20 20 20 20 |ase"</p>|.<p>    |
|00005d60| 75 6e 6c 6f 63 6b 20 73 | 63 72 65 65 6e 3c 2f 70 |unlock s|creen</p|
|00005d70| 3e 0a 3c 70 3e 20 20 65 | 6e 64 20 69 66 3c 2f 70 |>.<p>  e|nd if</p|
|00005d80| 3e 0a 3c 70 3e 65 6e 64 | 20 6d 6f 75 73 65 55 70 |>.<p>end| mouseUp|
|00005d90| 3c 2f 70 3e 0a 3c 70 3e | 3c 2f 70 3e 09 00 00 00 |</p>.<p>|</p>....|
|00005da0| 00 00 0a 00 00 04 0d 00 | 05 68 65 6c 70 00 04 86 |........|.help...|
|00005db0| 29 78 00 13 00 0d 01 19 | 6f 6e 20 6c 69 6e 6b 43 |)x......|on linkC|
|00005dc0| 6c 69 63 6b 65 64 20 70 | 4c 69 6e 6b 0a 20 20 69 |licked p|Link.  i|
|00005dd0| 66 20 77 6f 72 64 20 32 | 20 6f 66 20 63 6c 69 63 |f word 2| of clic|
|00005de0| 6b 4c 69 6e 65 28 29 20 | 3c 20 33 31 20 74 68 65 |kLine() |< 31 the|
|00005df0| 6e 0a 20 20 20 20 73 65 | 6c 65 63 74 20 6c 69 6e |n.    se|lect lin|
|00005e00| 65 20 28 6c 69 6e 65 4f | 66 66 73 65 74 28 70 4c |e (lineO|ffset(pL|
|00005e10| 69 6e 6b 2c 74 68 65 20 | 74 65 78 74 20 6f 66 20 |ink,the |text of |
|00005e20| 6d 65 2c 33 31 29 2b 33 | 31 29 20 6f 66 20 6d 65 |me,31)+3|1) of me|
|00005e30| 0a 20 20 20 20 73 65 74 | 20 74 68 65 20 73 63 72 |.    set| the scr|
|00005e40| 6f 6c 6c 20 6f 66 20 6d | 65 20 74 6f 20 74 68 65 |oll of m|e to the|
|00005e50| 20 73 63 72 6f 6c 6c 20 | 6f 66 20 6d 65 20 2b 20 | scroll |of me + |
|00005e60| 74 68 65 20 68 65 69 67 | 68 74 20 6f 66 20 6d 65 |the heig|ht of me|
|00005e70| 20 2d 20 32 35 0a 20 20 | 65 6c 73 65 20 69 66 20 | - 25.  |else if |
|00005e80| 63 68 61 72 20 31 20 74 | 6f 20 34 20 6f 66 20 70 |char 1 t|o 4 of p|
|00005e90| 4c 69 6e 6b 20 69 73 20 | 22 68 74 74 70 22 20 74 |Link is |"http" t|
|00005ea0| 68 65 6e 0a 20 20 20 20 | 72 65 76 47 6f 55 52 4c |hen.    |revGoURL|
|00005eb0| 20 70 4c 69 6e 6b 0a 20 | 20 65 6e 64 20 69 66 0a | pLink. | end if.|
|00005ec0| 65 6e 64 20 6c 69 6e 6b | 43 6c 69 63 6b 65 64 0a |end link|Clicked.|
|00005ed0| 00 00 00 00 00 80 00 00 | 05 00 22 01 88 01 52 00 |........|.."...R.|
|00005ee0| 00 00 00 00 08 00 08 00 | 08 00 08 00 00 00 01 00 |........|........|
|00005ef0| 19 18 00 0d 63 52 45 56 | 47 65 6f 6d 65 74 72 79 |....cREV|Geometry|
|00005f00| 00 00 00 00 17 1d 4d 61 | 73 74 65 72 2c 73 63 61 |......Ma|ster,sca|
|00005f10| 6c 65 42 6f 74 74 6f 6d | 4f 62 6a 65 63 74 53 69 |leBottom|ObjectSi|
|00005f20| 64 65 00 00 06 42 6f 74 | 74 6f 6d 07 4d 61 73 74 |de...Bot|tom.Mast|
|00005f30| 65 72 00 00 04 74 72 75 | 65 1a 4d 61 73 74 65 72 |er...tru|e.Master|
|00005f40| 2c 73 63 61 6c 65 4c 65 | 66 74 4f 62 6a 65 63 74 |,scaleLe|ftObject|
|00005f50| 52 65 66 00 00 00 19 4d | 61 73 74 65 72 2c 73 63 |Ref....M|aster,sc|
|00005f60| 61 6c 65 74 6f 70 4f 62 | 6a 65 63 74 52 65 66 00 |aletopOb|jectRef.|
|00005f70| 00 00 1c 4d 61 73 74 65 | 72 2c 73 63 61 6c 65 42 |...Maste|r,scaleB|
|00005f80| 6f 74 74 6f 6d 4f 62 6a | 65 63 74 52 65 66 00 00 |ottomObj|ectRef..|
|00005f90| 04 43 61 72 64 1b 4d 61 | 73 74 65 72 2c 73 63 61 |.Card.Ma|ster,sca|
|00005fa0| 6c 65 42 6f 74 74 6f 6d | 41 62 73 6f 6c 75 74 65 |leBottom|Absolute|
|00005fb0| 00 00 04 74 72 75 65 13 | 4d 61 73 74 65 72 2c 73 |...true.|Master,s|
|00005fc0| 63 61 6c 65 42 6f 74 74 | 6f 6d 00 00 04 74 72 75 |caleBott|om...tru|
|00005fd0| 65 1b 4d 61 73 74 65 72 | 2c 73 63 61 6c 65 4c 65 |e.Master|,scaleLe|
|00005fe0| 66 74 4f 62 6a 65 63 74 | 53 69 64 65 00 00 06 63 |ftObject|Side...c|
|00005ff0| 65 6e 74 65 72 1a 4d 61 | 73 74 65 72 2c 73 63 61 |enter.Ma|ster,sca|
|00006000| 6c 65 54 6f 70 4f 62 6a | 65 63 74 53 69 64 65 00 |leTopObj|ectSide.|
|00006010| 00 06 63 65 6e 74 65 72 | 14 4d 61 73 74 65 72 2c |..center|.Master,|
|00006020| 65 78 70 65 63 74 65 64 | 52 65 63 74 00 00 0c 35 |expected|Rect...5|
|00006030| 2c 33 34 2c 33 39 37 2c | 33 37 32 1b 4d 61 73 74 |,34,397,|372.Mast|
|00006040| 65 72 2c 73 63 61 6c 65 | 62 6f 74 74 6f 6d 44 69 |er,scale|bottomDi|
|00006050| 73 74 61 6e 63 65 00 00 | 03 2d 33 32 1a 4d 61 73 |stance..|.-32.Mas|
|00006060| 74 65 72 2c 73 63 61 6c | 65 52 69 67 68 74 41 62 |ter,scal|eRightAb|
|00006070| 73 6f 6c 75 74 65 00 00 | 05 66 61 6c 73 65 12 4d |solute..|.false.M|
|00006080| 61 73 74 65 72 2c 73 63 | 61 6c 65 52 69 67 68 74 |aster,sc|aleRight|
|00006090| 00 00 05 66 61 6c 73 65 | 1a 4d 61 73 74 65 72 2c |...false|.Master,|
|000060a0| 73 63 61 6c 65 72 69 67 | 68 74 44 69 73 74 61 6e |scalerig|htDistan|
|000060b0| 63 65 00 00 01 30 18 4d | 61 73 74 65 72 2c 73 63 |ce...0.M|aster,sc|
|000060c0| 61 6c 65 54 6f 70 41 62 | 73 6f 6c 75 74 65 00 00 |aleTopAb|solute..|
|000060d0| 05 66 61 6c 73 65 1b 4d | 61 73 74 65 72 2c 73 63 |.false.M|aster,sc|
|000060e0| 61 6c 65 52 69 67 68 74 | 4f 62 6a 65 63 74 52 65 |aleRight|ObjectRe|
|000060f0| 66 00 00 00 1c 4d 61 73 | 74 65 72 2c 73 63 61 6c |f....Mas|ter,scal|
|00006100| 65 52 69 67 68 74 4f 62 | 6a 65 63 74 53 69 64 65 |eRightOb|jectSide|
|00006110| 00 00 06 63 65 6e 74 65 | 72 19 4d 61 73 74 65 72 |...cente|r.Master|
|00006120| 2c 73 63 61 6c 65 4c 65 | 66 74 41 62 73 6f 6c 75 |,scaleLe|ftAbsolu|
|00006130| 74 65 00 00 05 66 61 6c | 73 65 10 4d 61 73 74 65 |te...fal|se.Maste|
|00006140| 72 2c 73 63 61 6c 65 54 | 6f 70 00 00 05 66 61 6c |r,scaleT|op...fal|
|00006150| 73 65 11 4d 61 73 74 65 | 72 2c 73 63 61 6c 65 4c |se.Maste|r,scaleL|
|00006160| 65 66 74 00 00 05 66 61 | 6c 73 65 13 4d 61 73 74 |eft...fa|lse.Mast|
|00006170| 65 72 2c 63 61 72 64 52 | 61 6e 6b 69 6e 67 00 00 |er,cardR|anking..|
|00006180| 01 31 19 4d 61 73 74 65 | 72 2c 73 63 61 6c 65 6c |.1.Maste|r,scalel|
|00006190| 65 66 74 44 69 73 74 61 | 6e 63 65 00 00 01 30 18 |eftDista|nce...0.|
|000061a0| 4d 61 73 74 65 72 2c 73 | 63 61 6c 65 74 6f 70 44 |Master,s|caletopD|
|000061b0| 69 73 74 61 6e 63 65 00 | 00 01 30 18 00 0c 63 52 |istance.|..0...cR|
|000061c0| 45 56 47 65 6e 65 72 61 | 6c 00 00 00 00 08 0f 73 |EVGenera|l......s|
|000061d0| 63 72 69 70 74 43 68 65 | 63 6b 73 75 6d 00 00 10 |criptChe|cksum...|
|000061e0| 4f 52 cb 67 43 7d 6f c7 | 31 44 a9 39 aa eb ba 5a |OR.gC}o.|1D.9...Z|
|000061f0| 0c 72 65 76 55 6e 69 71 | 75 65 49 44 00 00 0d 31 |.revUniq|ueID...1|
|00006200| 30 30 34 31 31 33 30 33 | 36 30 32 33 0a 62 6f 6f |00411303|6023.boo|
|00006210| 6b 6d 61 72 6b 73 00 00 | 00 0c 68 61 6e 64 6c 65 |kmarks..|..handle|
|00006220| 72 4c 69 73 74 00 00 0b | 6c 69 6e 6b 43 6c 69 63 |rList...|linkClic|
|00006230| 6b 65 64 0b 74 65 6d 70 | 53 63 72 69 70 74 00 00 |ked.temp|Script..|
|00006240| 00 0c 70 72 65 76 48 61 | 6e 64 6c 65 72 00 00 07 |..prevHa|ndler...|
|00006250| 6d 6f 75 73 65 55 70 10 | 73 63 72 69 70 74 53 65 |mouseUp.|scriptSe|
|00006260| 6c 65 63 74 69 6f 6e 00 | 00 0f 63 68 61 72 20 32 |lection.|..char 2|
|00006270| 36 34 20 74 6f 20 32 36 | 33 07 73 63 72 69 70 74 |64 to 26|3.script|
|00006280| 00 01 52 3c 70 3e 6f 6e | 20 6c 69 6e 6b 43 6c 69 |..R<p>on| linkCli|
|00006290| 63 6b 65 64 20 70 4c 69 | 6e 6b 3c 2f 70 3e 0a 3c |cked pLi|nk</p>.<|
|000062a0| 70 3e 20 20 69 66 20 77 | 6f 72 64 20 32 20 6f 66 |p>  if w|ord 2 of|
|000062b0| 20 63 6c 69 63 6b 4c 69 | 6e 65 28 29 20 26 6c 74 | clickLi|ne() &lt|
|000062c0| 3b 20 33 31 20 74 68 65 | 6e 3c 2f 70 3e 0a 3c 70 |; 31 the|n</p>.<p|
|000062d0| 3e 20 20 20 20 73 65 6c | 65 63 74 20 6c 69 6e 65 |>    sel|ect line|
|000062e0| 20 28 6c 69 6e 65 4f 66 | 66 73 65 74 28 70 4c 69 | (lineOf|fset(pLi|
|000062f0| 6e 6b 2c 74 68 65 20 74 | 65 78 74 20 6f 66 20 6d |nk,the t|ext of m|
|00006300| 65 2c 33 31 29 2b 33 31 | 29 20 6f 66 20 6d 65 3c |e,31)+31|) of me<|
|00006310| 2f 70 3e 0a 3c 70 3e 20 | 20 20 20 73 65 74 20 74 |/p>.<p> |   set t|
|00006320| 68 65 20 73 63 72 6f 6c | 6c 20 6f 66 20 6d 65 20 |he scrol|l of me |
|00006330| 74 6f 20 74 68 65 20 73 | 63 72 6f 6c 6c 20 6f 66 |to the s|croll of|
|00006340| 20 6d 65 20 2b 20 74 68 | 65 20 68 65 69 67 68 74 | me + th|e height|
|00006350| 20 6f 66 20 6d 65 20 2d | 20 32 35 3c 2f 70 3e 0a | of me -| 25</p>.|
|00006360| 3c 70 3e 20 20 65 6c 73 | 65 20 69 66 20 63 68 61 |<p>  els|e if cha|
|00006370| 72 20 31 20 74 6f 20 34 | 20 6f 66 20 70 4c 69 6e |r 1 to 4| of pLin|
|00006380| 6b 20 69 73 20 22 68 74 | 74 70 22 20 74 68 65 6e |k is "ht|tp" then|
|00006390| 3c 2f 70 3e 0a 3c 70 3e | 20 20 20 20 72 65 76 47 |</p>.<p>|    revG|
|000063a0| 6f 55 52 4c 20 70 4c 69 | 6e 6b 3c 2f 70 3e 0a 3c |oURL pLi|nk</p>.<|
|000063b0| 70 3e 20 20 65 6e 64 20 | 69 66 3c 2f 70 3e 0a 3c |p>  end |if</p>.<|
|000063c0| 70 3e 65 6e 64 20 6c 69 | 6e 6b 43 6c 69 63 6b 65 |p>end li|nkClicke|
|000063d0| 64 3c 2f 70 3e 0b 00 00 | 04 01 0c 00 09 43 6f 6e |d</p>...|.....Con|
|000063e0| 74 65 6e 74 73 00 0d 00 | 00 00 08 00 1a 00 00 00 |tents...|........|
|000063f0| 08 0c 00 01 00 0c 00 37 | 55 73 69 6e 67 20 64 61 |.......7|Using da|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.